Displaying Password

--Apple-Mail-2--316273016
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=WINDOWS-1252;
delsp=yes;
format=flowed

Never mind.
Got it.

$replaceArray =3D array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', =20
'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w', =20=

'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
$replaceWith =3D array=20
('=95','=95','=95','=95','=95','=95','=95','=95','=95','=95' ,'=95','=95','=
=95','=95','=95','=95','=95','=95'=20
,'=95','=95','=95','=95','=95','=95','=95','=95','=95','=95' ,'=95','=95','=
=95','=95','=95','=95','=95','=95'=20
);
$UserPassword =3D str_replace($replaceArray, $replaceWith, =20
$UserPassword); //hide pasword

Best,

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-2--316273016--

Re: Displaying Password

Hi,

You can't be serious with that. You should try The next code:

$UserPassword = str_repeat("•", strlen($UserPassword));

Enjoy. (I hope that you are not a programmer)

--------------------------------------------------
From: "Karl DeSaulniers"
Sent: Tuesday, December 22, 2009 6:12 AM
To:
Subject: [PHP-DB] Displaying Password

> Never mind.
> Got it.
>
> $replaceArray = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i',
> 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w',
> 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
> $replaceWith = array
> ('•','•','•','•','•','•','•','•','•','•','•','•','•','•','•' ,'•','•','•'
> ,'•','•','•','•','•','•','•','•','•','•','•','•','•','•','•' ,'•','•','•'
> );
> $UserPassword = str_replace($replaceArray, $replaceWith,
> $UserPassword); //hide pasword
>
> Best,
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Displaying Password

--Apple-Mail-2--253418963
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=WINDOWS-1252;
format=flowed

Hi Rick,
Yes you are correct. I do not store a plan text password.
The conversion code is so they cant read the encryption either.

If you cant read the encrypted text, you cant decrypt it right?

Thanks for your response.

Karl

On Dec 22, 2009, at 10:54 AM, lists-mysql wrote:

> This shouldn't be an issue as you should *never* be storing a user's
> password in plaintext in the first place.
>
> When a password is first set, encrypt it. If a user needs a new
> password, send a password recovery url to the email address on file
> (or some other like-minded approach).
>
> - Rick
>
> ------------ Original Message ------------
>> Date: Monday, December 21, 2009 11:12:48 PM -0600
>> From: Karl DeSaulniers
>> To: php-db@lists.php.net
>> Subject: [PHP-DB] Displaying Password
>>
>> Never mind.
>> Got it.
>>
>> $replaceArray =3D array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i',
>> 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v',
>> 'w', 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9',
>> '0');
>> $replaceWith =3D
>> array('=95','=95','=95','=95','=95','=95','=95','=95','=95', '=95',
>> '=95','=95','=95','=95','=95','=95','=95','=95','=95','=95', '=95',
>> '=95','=95','=95','=95','=95','=95','=95','=95','=95','=95', '=95',
>> '=95','=95','=95','=95');
>> $UserPassword =3D str_replace($replaceArray, $replaceWith,
>> $UserPassword); //hide pasword
>>
>> Best,
>>
>> Karl DeSaulniers
>> Design Drumm
>> http://designdrumm.com
>>
>
> ------------ End Original Message ------------
>
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-2--253418963--

Re: Displaying Password

--Apple-Mail-3--253148110
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=WINDOWS-1252;
delsp=yes;
format=flowed

Thanks for the blunt response.
No, I am not a programer yet. Still very novice.
I was aware that there was a way to do that, but I am still learning.
Thank you for the tip.

Karl

On Dec 22, 2009, at 11:44 AM, =20
wrote:

> Hi,
>
> You can't be serious with that. You should try The next code:
>
> $UserPassword =3D str_repeat("•", strlen($UserPassword));
>
> Enjoy. (I hope that you are not a programmer)
>
> --------------------------------------------------
> From: "Karl DeSaulniers"
> Sent: Tuesday, December 22, 2009 6:12 AM
> To:
> Subject: [PHP-DB] Displaying Password
>
>> Never mind.
>> Got it.
>>
>> $replaceArray =3D array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i',
>> 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w',
>> 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
>> $replaceWith =3D array
>> ('=95','=95','=95','=95','=95','=95','=95','=95','=95','=95' ,'=95','=95=
','=95','=95','=95','=95','=95',=20
>> '=95'
>> ,'=95','=95','=95','=95','=95','=95','=95','=95','=95','=95' ,'=95','=95=
','=95','=95','=95','=95','=95',=20
>> '=95'
>> );
>> $UserPassword =3D str_replace($replaceArray, $replaceWith,
>> $UserPassword); //hide pasword
>>
>> Best,
>>
>> Karl DeSaulniers
>> Design Drumm
>> http://designdrumm.com
>>
>
> --=20
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-3--253148110--

Re: Displaying Password

Hi Karl,

>=20
> Yes you are correct. I do not store a plan text password.

Great stuff - so many systems I've seen use plain-text passwords it's =
little wonder there's so much data theft.


> If you cant read the encrypted text, you cant decrypt it right?

Wrong. There are two-way encryption methods requiring the use of a =
common key, and an initialization vector for some protocols - see the =
mcrypt library which PHP can use (I had a play around with it quite =
recently.)

http://uk2.php.net/manual/en/function.mcrypt-decrypt.php

Regards,
Andy=

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Displaying Password

--Apple-Mail-5--252549680
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

Hi Andy,
Sorry, I guess I should have explained better.
I was speaking about what comes up on the preview page for the
information.
I wanted the passwords to display as bullets so they could not see
the encrypted text,
nor be able to copy the text and try it in any decryption process if
they happened to get
to that page where the information can be displayed.

Karl

On Dec 22, 2009, at 4:49 PM, Andy Shellam wrote:

> Hi Karl,
>
>>
>> Yes you are correct. I do not store a plan text password.
>
> Great stuff - so many systems I've seen use plain-text passwords
> it's little wonder there's so much data theft.
>
>
>> If you cant read the encrypted text, you cant decrypt it right?
>
> Wrong. There are two-way encryption methods requiring the use of a
> common key, and an initialization vector for some protocols - see
> the mcrypt library which PHP can use (I had a play around with it
> quite recently.)
>
> http://uk2.php.net/manual/en/function.mcrypt-decrypt.php
>
> Regards,
> Andy

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-5--252549680--

Re: Displaying Password

--Apple-Mail-6--252383732
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

Thanks for the tip on the mcrypt.
I actually had read up a little about it.
I will have to investigate more now.
Thanks for the suggestion.

Karl


On Dec 22, 2009, at 4:54 PM, Karl DeSaulniers wrote:

> Hi Andy,
> Sorry, I guess I should have explained better.
> I was speaking about what comes up on the preview page for the
> information.
> I wanted the passwords to display as bullets so they could not see
> the encrypted text,
> nor be able to copy the text and try it in any decryption process
> if they happened to get
> to that page where the information can be displayed.
>
> Karl
>
> On Dec 22, 2009, at 4:49 PM, Andy Shellam wrote:
>
>> Hi Karl,
>>
>>>
>>> Yes you are correct. I do not store a plan text password.
>>
>> Great stuff - so many systems I've seen use plain-text passwords
>> it's little wonder there's so much data theft.
>>
>>
>>> If you cant read the encrypted text, you cant decrypt it right?
>>
>> Wrong. There are two-way encryption methods requiring the use of
>> a common key, and an initialization vector for some protocols -
>> see the mcrypt library which PHP can use (I had a play around with
>> it quite recently.)
>>
>> http://uk2.php.net/manual/en/function.mcrypt-decrypt.php
>>
>> Regards,
>> Andy
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-6--252383732--

Re: Displaying Password

--Apple-Mail-7--251884364
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=WINDOWS-1252;
delsp=yes;
format=flowed

I see. Good point.
Forgive me with my noob approach.
I am creating my first database and I guess I was just thinking of =20
how to get everything to work first then though "well I can't have =20
the passwords be visible".
I would probably have eventually came to the same conclusion,
so you all may have saved me a load of unnecessary work.
But thank you for the tips on string conversion.
Every little bit helps.

Karl


On Dec 22, 2009, at 4:58 PM, lists-php wrote:

> correct. if they can't see the encrypted value it's harder to try to
> decrypt it but ... there's no reason for the encrypted value to be
> in "public view" in the first place.
>
> when a user enters their password you pass that to your back-end
> where you encrypt it and test it against the one-way hash that's
> stored in your db. if it matches, fine, if not you reprompt/reject.
> but throughout, the stored hash never sees the light of day and the
> hash of what the user enters is only in the back-end. there's no
> reason for any version of a password (user-entered string, hash of
> user-entered string, hash of stored pw) to be on any page that a
> user can view (rendered or source). that being the case, there's no
> need to be playing obfuscation games.
>
> if you have a "preview page" and you don't want the user to see any
> version of the pw there, then don't put it there. if you convert it
> to some form of blanking, then there's nothing for them to preview
> anyway, so don't waste the effort.
>
> - Rick
>
>
>
> ------------ Original Message ------------
>> Date: Tuesday, December 22, 2009 04:40:22 PM -0600
>> From: Karl DeSaulniers
>> Subject: Re: [PHP-DB] Displaying Password
>>
>> Hi Rick,
>> Yes you are correct. I do not store a plan text password.
>> The conversion code is so they cant read the encryption either.
>>
>> If you cant read the encrypted text, you cant decrypt it right?
>>
>> Thanks for your response.
>>
>> Karl
>>
>> On Dec 22, 2009, at 10:54 AM, lists-mysql wrote:
>>
>>> This shouldn't be an issue as you should *never* be storing a
>>> user's password in plaintext in the first place.
>>>
>>> When a password is first set, encrypt it. If a user needs a new
>>> password, send a password recovery url to the email address on
>>> file (or some other like-minded approach).
>>>
>>> - Rick
>>>
>>> ------------ Original Message ------------
>>>> Date: Monday, December 21, 2009 11:12:48 PM -0600
>>>> From: Karl DeSaulniers
>>>> To: php-db@lists.php.net
>>>> Subject: [PHP-DB] Displaying Password
>>>>
>>>> Never mind.
>>>> Got it.
>>>>
>>>> $replaceArray =3D array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h',
>>>> 'i', 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u',
>>>> 'v', 'w', 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8',
>>>> '9', '0');
>>>> $replaceWith =3D
>>>> array('=95','=95','=95','=95','=95','=95','=95','=95','=95', '=95
>>>> ',
>>>> '=95','=95','=95','=95','=95','=95','=95','=95','=95','=95', '=95
>>>> ',
>>>> '=95','=95','=95','=95','=95','=95','=95','=95','=95','=95', '=95
>>>> ', '=95','=95','=95','=95');
>>>> $UserPassword =3D str_replace($replaceArray, $replaceWith,
>>>> $UserPassword); //hide pasword
>>>>
>>>> Best,
>>>>
>>>> Karl DeSaulniers
>>>> Design Drumm
>>>> http://designdrumm.com
>>>>
>>>
>>> ------------ End Original Message ------------
>>>
>>>
>>
>> Karl DeSaulniers
>> Design Drumm
>> http://designdrumm.com
>>
>
> ------------ End Original Message ------------
>
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-7--251884364--

Re: Displaying Password

--Apple-Mail-8--250551004
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=WINDOWS-1252;
delsp=yes;
format=flowed

Worked like a charm.
Thanks for that.

Karl

On Dec 22, 2009, at 11:44 AM, =20
wrote:

> Hi,
>
> You can't be serious with that. You should try The next code:
>
> $UserPassword =3D str_repeat("•", strlen($UserPassword));
>
> Enjoy. (I hope that you are not a programmer)
>
> --------------------------------------------------
> From: "Karl DeSaulniers"
> Sent: Tuesday, December 22, 2009 6:12 AM
> To:
> Subject: [PHP-DB] Displaying Password
>
>> Never mind.
>> Got it.
>>
>> $replaceArray =3D array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i',
>> 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't', 'u', 'v', 'w',
>> 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
>> $replaceWith =3D array
>> ('=95','=95','=95','=95','=95','=95','=95','=95','=95','=95' ,'=95','=95=
','=95','=95','=95','=95','=95',=20
>> '=95'
>> ,'=95','=95','=95','=95','=95','=95','=95','=95','=95','=95' ,'=95','=95=
','=95','=95','=95','=95','=95',=20
>> '=95'
>> );
>> $UserPassword =3D str_replace($replaceArray, $replaceWith,
>> $UserPassword); //hide pasword
>>
>> Best,
>>
>> Karl DeSaulniers
>> Design Drumm
>> http://designdrumm.com
>>
>
> --=20
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-8--250551004--

RE: Displaying Password - oy vey...

> > You can't be serious with that?!

LOL. Exactly what I was thinking. W.T.F?
http://www.youtube.com/watch?v=pXhKzY0BKwY

> > You should try The next code:
> >
> > $UserPassword = str_repeat("•", strlen($UserPassword));
> >
> > Enjoy. (I hope that you are not a programmer)

....and this is why good programmers can't find jobs in the sea of bad
programmers. Everyone puts "LAMP developer" or "PHP developer" on their
resume, but there is a HUGE difference between knowing syntax (i.e. below
example) and UNDERSTANDING a language (above example). Recruiters don't
know the difference and the resume with the most buzzwords gets chosen, and
the poor company is burdened with testing each candidate (this assumes they
known enough about the language themselves to test someone), but more
likely, sucky-coder gets paired up with ignorant-company and hence we have
horribly buggy bloated programs to use. *sigh*

It's up there with people that do this kind of excessive crap:

if ($foo == true)
{
$bar = 5;
}
elseif ($foo == false)
{
$bar = 6;
}

When a simple:

$bar = ($foo) ? 5 : 6;

Would do the trick.

I have often wished there were licenses required to code. You need a
license to drive a vehicle. You need one to operate machinery. Why is it
that someone needs a license to cut my hair even (which will grow back in a
worst case scenario)? But yet the things we rely upon every day to keep our
homes, offices, phones, cars, web and cities functioning can be coded by
any hack with access to a computer? One doesn't even need a degree or any
schooling! It's absolutely absurd.

> > --------------------------------------------------
> >
> >>
> >> $replaceArray = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i',
> >> 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't',
> 'u', 'v', 'w',
> >> 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
> >> $replaceWith = array
> >>
> ('.','.','.','.','.','.','.','.','.','.','.','.','.','.','.' ,'.','.',
> >> '.'
> >>
> ,'.','.','.','.','.','.','.','.','.','.','.','.','.','.','.' ,'.','.',
> >> '.'
> >> );
> >> $UserPassword = str_replace($replaceArray, $replaceWith,
> >> $UserPassword); //hide pasword

[names removed to protect the guilty]


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Displaying Password - orale...

--Apple-Mail-10--239904523
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

WOW, thank you for that.
Guess I should have kept that question to myself and dove into the
manuals a little more, but
didn't think I would get crucified for asking help. Everyone has to
start somewhere and no one knows everything when they start.
I agree that one should get a degree or maaany hours of work behind
them before entering the world and taking jobs, but
at least I am asking for direction and help to become the wonderful
programer you already are.


Karl (I'm the guilty party, but not a hack)

PS: if it makes you feel any better, I am making this for myself and
I do not have "lead programer" on my CareerBuilder profile.



On Dec 22, 2009, at 7:39 PM, Daevid Vincent wrote:

>>> You can't be serious with that?!
>
> LOL. Exactly what I was thinking. W.T.F?
> http://www.youtube.com/watch?v=pXhKzY0BKwY
>
>>> You should try The next code:
>>>
>>> $UserPassword = str_repeat("•", strlen($UserPassword));
>>>
>>> Enjoy. (I hope that you are not a programmer)
>
> ...and this is why good programmers can't find jobs in the sea of bad
> programmers. Everyone puts "LAMP developer" or "PHP developer" on
> their
> resume, but there is a HUGE difference between knowing syntax (i.e.
> below
> example) and UNDERSTANDING a language (above example). Recruiters
> don't
> know the difference and the resume with the most buzzwords gets
> chosen, and
> the poor company is burdened with testing each candidate (this
> assumes they
> known enough about the language themselves to test someone), but more
> likely, sucky-coder gets paired up with ignorant-company and hence
> we have
> horribly buggy bloated programs to use. *sigh*
>
> It's up there with people that do this kind of excessive crap:
>
> if ($foo == true)
> {
> $bar = 5;
> }
> elseif ($foo == false)
> {
> $bar = 6;
> }
>
> When a simple:
>
> $bar = ($foo) ? 5 : 6;
>
> Would do the trick.
>
> I have often wished there were licenses required to code. You need a
> license to drive a vehicle. You need one to operate machinery. Why
> is it
> that someone needs a license to cut my hair even (which will grow
> back in a
> worst case scenario)? But yet the things we rely upon every day to
> keep our
> homes, offices, phones, cars, web and cities functioning can be
> coded by
> any hack with access to a computer? One doesn't even need a degree
> or any
> schooling! It's absolutely absurd.
>
>>> --------------------------------------------------
>>>
>>>>
>>>> $replaceArray = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i',
>>>> 'j', 'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't',
>> 'u', 'v', 'w',
>>>> 'x', 'y', 'z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');
>>>> $replaceWith = array
>>>>
>> ('.','.','.','.','.','.','.','.','.','.','.','.','.','.','.' ,'.','.',
>>>> '.'
>>>>
>> ,'.','.','.','.','.','.','.','.','.','.','.','.','.','.','.' ,'.','.',
>>>> '.'
>>>> );
>>>> $UserPassword = str_replace($replaceArray, $replaceWith,
>>>> $UserPassword); //hide pasword
>
> [names removed to protect the guilty]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-10--239904523--

Re: Displaying Password - oy vey...

--Apple-Mail-11--238817629
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

Daevid,
Just so you know. Your site does not work on a MAC.
Definitely not on Safari and your menus on Firefox (but some things
work on Firefox)
and I don't even use IE since they dropped support, so I wouldn't know.
Not sure if your are particular to PC or LINUX.
Just FYI.

Me..
I am an entrepreneur and don't have a lot of money,
so I must learn things on my own to keep my business growing.
Would love to go get the degree, but that is some time away.
In the mean time I have to get this created.
Just out of curiosity, does my site work on your system?
Also, I saw some of the things you worked on. Nice work.
(I see your serious about your recruiter comment now)
Do you have a suggestion where I can get PHP/MySQL certified?
or a good dummies book?

Best,

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-11--238817629--

RE: Displaying Password - orale...

> Guess I should have kept that question to myself and dove into the
manuals a little more, but
> didn't think I would get crucified for asking help. Everyone has to
> start somewhere and no one knows everything when they start.

Let me apologize. I didn't mean to chastise you specifically. That is why I
removed the names from the email. And I also did jump in late to the
thread, I was under the impression that the big block of code was what
someone else had suggested as a solution to an OP's question. I didn't
realize it was your code you were trying to ask the list about.

> Just so you know. Your site does not work on a MAC.

It actually does work on a Mac, just not in Safari ;-)

I'm aware of this, and unfortunately, it's a defunct JavaScript library
that is causing the issue. The library to do those fancy windows is all
written in German and then minified, so debugging it is just a nightmare I
don't have the time or care to dig into for a browser that is 4% of the
market ( http://marketshare.hitslink.com/browser-market-share.aspx?qp rid=0
)

> Definitely not on Safari and your menus on Firefox (but some things work
on Firefox)

All of it should work in Firefox. I use Firefox on Ubuntu and XP (as well
as IE6, IE7 and IE8)
What doesn't work in Firefox on the Mac?

> Not sure if your are particular to PC or LINUX.

Yes, I am. I bought a Dell Mini9 and hackintoshed it since several
friends/fanboys of mine kept extolling the virtues of the mighty OSX. I
really WANTED to like OSX. But aside from looking pretty, I found it too
dumbed down for me. I like more control over my OS, and when I press the
'DEL' button on a file, well, it damn well should 'DELete'. ;-)

> Just FYI.
>
> Me..
> I am an entrepreneur and don't have a lot of money,

As am I.

> so I must learn things on my own to keep my business growing.

Understood and empathize.

> Would love to go get the degree, but that is some time away.
> In the mean time I have to get this created.
> Just out of curiosity, does my site work on your system?

I believe so. It loads and does a few things. Not sure how much is
completed or not to say what it's supposed to do or not do...

> Also, I saw some of the things you worked on. Nice work.

Thank you.

> (I see your serious about your recruiter comment now)

Yes. They bug the shit out of me.

> Do you have a suggestion where I can get PHP/MySQL certified?

I've never been to one, but Zend offers courses that may be worth checking
into.

> or a good dummies book?

I find the php.net site to be the absolute best source of examples and
information.

d


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Displaying Password

--Apple-Mail-30--223552986
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed

David,
If you ever have a question, don't hesitate to ask. Same to anyone.
I may have already ran across the problem and found a solution, who
knows.
I have a feeling I will have more questions than any of you but I
digress..
Thanks for the complement. I try not to get into knock down drag outs
on email lists.
I save that for the bars :)) Besides, I feel their pain.
So many people think they can build flash sites (that is what I do)
and I miss out on a lot of jobs because like many,
I have relied on placement agencies. Another reason why I am building
this. ;)

Blessings to you,

- Karl DeSaulniers

"The best people in the world are the ones who help each other make
it turn. After all, where all here together."


On Dec 22, 2009, at 10:16 PM, David McGlone wrote:

> On Tuesday 22 December 2009 18:05:57 you wrote:
>> I see. Good point.
>> Forgive me with my noob approach.
>> I am creating my first database and I guess I was just thinking of
>> how to get everything to work first then though "well I can't have
>> the passwords be visible".
>> I would probably have eventually came to the same conclusion,
>> so you all may have saved me a load of unnecessary work.
>> But thank you for the tips on string conversion.
>> Every little bit helps.
>>
>
> Hi Karl,
>
> I was wondering, since you are new at programming PHP/MySQL, maybe
> you and I
> could learn together. I've been learning for a little over a year,
> and just
> thought it might be helpful.
>
> By the way, you handled yourself well when some of them started
> flaming you and
> don't let them discourage you.
>
> --
> Blessings
> David M.
> I have been driven to my knees many times by the overwhelming
> conviction that
> I had nowhere else to go.

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-30--223552986--

Re: Displaying Password - orale...

--Apple-Mail-31--222316629
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
format=flowed

Thanks for the Zend tip Daevid.
I did some search and found Zend Studio for MAC 5.5.
it's $299, but thats a goal at least.

http://www.tucows.com/preview/504387

Best,

Karl


--Apple-Mail-31--222316629--

Re: Displaying Password - orale...

--Apple-Mail-32--222261215
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
delsp=yes;
format=flowed


On Dec 22, 2009, at 10:01 PM, Daevid Vincent wrote:

>> Guess I should have kept that question to myself and dove into the
> manuals a little more, but
>> didn't think I would get crucified for asking help. Everyone has to
>> start somewhere and no one knows everything when they start.
>
> Let me apologize.

Accepted. :)

> I didn't mean to chastise you specifically. That is why I
> removed the names from the email. And I also did jump in late to the
> thread, I was under the impression that the big block of code was what
> someone else had suggested as a solution to an OP's question. I didn't
> realize it was your code you were trying to ask the list about.

No problem, I enjoy blunt answers to questions. I've had enough
sweets in my life, I dont need anymore sugar coating.
Just caught me off guard. And yes unfortuantely, that was my code.
But that is why I'm here ;)

>
>> Just so you know. Your site does not work on a MAC.
>
> It actually does work on a Mac, just not in Safari ;-)
>
> I'm aware of this, and unfortunately, it's a defunct JavaScript
> library
> that is causing the issue. The library to do those fancy windows is
> all
> written in German and then minified, so debugging it is just a
> nightmare I
> don't have the time or care to dig into for a browser that is 4% of
> the

You sure about this number, I mean there is now safari on all iPhones
as well and they have a BIIIG market.
No matter.

> market ( http://marketshare.hitslink.com/browser-market-share.aspx?
> qprid=0
> )
>
>> Definitely not on Safari and your menus on Firefox (but some
>> things work
> on Firefox)
>
> All of it should work in Firefox. I use Firefox on Ubuntu and XP
> (as well
> as IE6, IE7 and IE8)

IE does not love us MAC people anymore, boo hoo :P
Nothing ever worked in it when it was on MAC anyways, so goo ridden.
Hell, its one of the only browsers I know that HAS to have special
code written (in almost any dynamic site)
that will make it work on IE. Too much work to do for a silverspoon
application.
I would rather force people to download Firefox or Safari. (On my own
projects of course)

> What doesn't work in Firefox on the Mac?
>

The menus were the worst thing when I looked in Firefox, but the main
panels and the nav to the left worked.
It was the top that was a little screwy. Might have been a CSS thing.

>> Not sure if your are particular to PC or LINUX.
>
> Yes, I am. I bought a Dell Mini9 and hackintoshed it since several
> friends/fanboys of mine kept extolling the virtues of the mighty
> OSX. I
> really WANTED to like OSX. But aside from looking pretty, I found
> it too
> dumbed down for me. I like more control over my OS, and when I
> press the
> 'DEL' button on a file, well, it damn well should 'DELete'. ;-)

Well you can do that by pressing the apple button + delete.

>
>> Just FYI.
>>
>> Me..
>> I am an entrepreneur and don't have a lot of money,
>
> As am I.
>
>> so I must learn things on my own to keep my business growing.
>
> Understood and empathize.
>
>> Would love to go get the degree, but that is some time away.
>> In the mean time I have to get this created.
>> Just out of curiosity, does my site work on your system?
>
> I believe so. It loads and does a few things. Not sure how much is
> completed or not to say what it's supposed to do or not do...
>
>> Also, I saw some of the things you worked on. Nice work.
>
> Thank you.
>
>> (I see your serious about your recruiter comment now)
>
> Yes. They bug the shit out of me.

If you want them to stop. Call them every day about jobs.

>
>> Do you have a suggestion where I can get PHP/MySQL certified?
>
> I've never been to one, but Zend offers courses that may be worth
> checking
> into.
>
>> or a good dummies book?
>
> I find the php.net site to be the absolute best source of examples and
> information.\

I do concur.

Best,


Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-32--222261215--

Help for a beginner

Hi everyone, first thank you for ALL help and the understanding that I am n=
ew to PHP and MySQL. This is a long email and for that I apologize but I am=
trying to provide as much detail as possible. If this is the wrong list to=
ask for help, kindly direct me to the proper authority.

I am trying to learn and I have built the following environment.

Windows Server 2008 Standard 32bit service Pack 2 with IIS7
mysql-essential-5.1.41-win32
php-5.3.1-nts-Win32-VC9-x86.msi
phpMyAdmin-3.2.4-english.zip


I followed the steps as detailed below (I already had IIS7 and CGI installe=
d)


1. Install CGI & PHP
http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/

2. Install MySQL
http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
=20
3. Install PHPMyAdmin
http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server=
-2008/2008-09-16/


After I completed the installations
1. If I navigate to the PHP directory and type php -info it spews a ton of =
data at me
AND
I created info.php which contains:
When I browse this, it correctly produces a page with all the info about=
my PHP server. Although I do not understand much of it I believe this conf=
irms PHP is working correctly with IIS

2. I open the MySQL CLI and perform the commands outlined in Step 23 at thi=
s page
http://www.bicubica.com/apache-php-mysql/index.php
This returns the expected results, confirming MySQL is working

3. PHP is configured to work with php_mysql.dll as per the steps in the tra=
insignal links above so I begin!
I go to the phpmyadmin page, enter root and my password and after a long ti=
me I get a FastCGI error. I am not ready to believe it because, in classic =
MS form, it has several VERY different potential causes, and I have covered=
all of those. Plus the error code is 0x00000000 which is like saying nothi=
ng... I start thinking maybe it is not connecting to the mYSQL server right=
, the instructions re: pma and the password made no sense to me so I fiddle=
with that with no change.


I write the mysql_test.php page in step 5 of http://www.bicubica.com/ap=
ache-php-mysql/index.php
This fails with: A connection attempt failed because the connected party=
did not properly respond after a period of time, or established connection=
failed because connected host has failed to respond.

Because the PHP failed I try with ASP...
<%
set conn=3DServer.CreateObject("ADODB.Connection")
conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3D=
test;User Id=3Droot;Password=3Dyouwish"
conn.open
Response.write("Connected")
conn.close
%>

This returns:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20
[Microsoft][ODBC Driver Manager] Data source name not found and no d=
efault driver specified=20
/test.asp, line 4

I believe I have established MySQL is working, but for some reason it appea=
rs that it cannot be "reached" This IS on the same server so firewall shoul=
d not be an issue, PLUS I confirmed the installer did create a hole. I turn=
off the MS firewall to be safe, no change.... I try a "repair" of MySQL, I=
uninstall, reboot and reinstall with no change.

NOTE: at several points I have tried iisreset and/or rebooting the system w=
ith no change.

I start to research the matter and my mind is now unglued. I found somethin=
g referencing using mcrypt with PHPMyAdmin to speed it up and wondered if m=
aybe the long delay before the FastCGI error could be resolved so I tracked=
down the dll, put it in my ext directory and changed my php.ini to reflect=
this -- file found at http://files.edin.dk/php/win32/mcrypt/

I found quite a bit about using libmysql.dll but there was no such file in =
my install, I pulled down the .zip package and that also did not contain it=
, I eventually found it in a 5.2.x archive but that does not seem to have h=
elped. I have tried enabling: only mysql, mysql AND mysqli, and only mysqli=
.. None of this seems to have done anything to change my situation.

Again, I apologize for the lengthy message, I hope I have accurately descri=
bed my issue in the right amount of detail.

Thank You!
Adam Sonzogni




=20

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Help for a beginner

Just a guess, as I have not tried a full stack in windows, but in any unix =
if you are connecting php and mysql, you need something in the middle like =
DBD::mysql

See if this helps: http://forums.mysql.com/read.php?51,189692,189856


-----Original Message-----
From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]
Sent: Wednesday, December 23, 2009 9:52 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Help for a beginner

Hi everyone, first thank you for ALL help and the understanding that I am n=
ew to PHP and MySQL. This is a long email and for that I apologize but I am=
trying to provide as much detail as possible. If this is the wrong list to=
ask for help, kindly direct me to the proper authority.

I am trying to learn and I have built the following environment.

Windows Server 2008 Standard 32bit service Pack 2 with IIS7
mysql-essential-5.1.41-win32
php-5.3.1-nts-Win32-VC9-x86.msi
phpMyAdmin-3.2.4-english.zip


I followed the steps as detailed below (I already had IIS7 and CGI installe=
d)


1. Install CGI & PHP
http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/

2. Install MySQL
http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/

3. Install PHPMyAdmin
http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server=
-2008/2008-09-16/


After I completed the installations
1. If I navigate to the PHP directory and type php -info it spews a ton of =
data at me
AND
I created info.php which contains:
When I browse this, it correctly produces a page with all the info about=
my PHP server. Although I do not understand much of it I believe this conf=
irms PHP is working correctly with IIS

2. I open the MySQL CLI and perform the commands outlined in Step 23 at thi=
s page
http://www.bicubica.com/apache-php-mysql/index.php
This returns the expected results, confirming MySQL is working

3. PHP is configured to work with php_mysql.dll as per the steps in the tra=
insignal links above so I begin!
I go to the phpmyadmin page, enter root and my password and after a long ti=
me I get a FastCGI error. I am not ready to believe it because, in classic =
MS form, it has several VERY different potential causes, and I have covered=
all of those. Plus the error code is 0x00000000 which is like saying nothi=
ng... I start thinking maybe it is not connecting to the mYSQL server right=
, the instructions re: pma and the password made no sense to me so I fiddle=
with that with no change.


I write the mysql_test.php page in step 5 of http://www.bicubica.com/ap=
ache-php-mysql/index.php
This fails with: A connection attempt failed because the connected party=
did not properly respond after a period of time, or established connection=
failed because connected host has failed to respond.

Because the PHP failed I try with ASP...
<%
set conn=3DServer.CreateObject("ADODB.Connection")
conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3D=
test;User Id=3Droot;Password=3Dyouwish"
conn.open
Response.write("Connected")
conn.close
%>

This returns:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no d=
efault driver specified
/test.asp, line 4

I believe I have established MySQL is working, but for some reason it appea=
rs that it cannot be "reached" This IS on the same server so firewall shoul=
d not be an issue, PLUS I confirmed the installer did create a hole. I turn=
off the MS firewall to be safe, no change.... I try a "repair" of MySQL, I=
uninstall, reboot and reinstall with no change.

NOTE: at several points I have tried iisreset and/or rebooting the system w=
ith no change.

I start to research the matter and my mind is now unglued. I found somethin=
g referencing using mcrypt with PHPMyAdmin to speed it up and wondered if m=
aybe the long delay before the FastCGI error could be resolved so I tracked=
down the dll, put it in my ext directory and changed my php.ini to reflect=
this -- file found at http://files.edin.dk/php/win32/mcrypt/

I found quite a bit about using libmysql.dll but there was no such file in =
my install, I pulled down the .zip package and that also did not contain it=
, I eventually found it in a 5.2.x archive but that does not seem to have h=
elped. I have tried enabling: only mysql, mysql AND mysqli, and only mysqli=
.. None of this seems to have done anything to change my situation.

Again, I apologize for the lengthy message, I hope I have accurately descri=
bed my issue in the right amount of detail.

Thank You!
Adam Sonzogni






--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Help for a beginner

Mr. Brookhouse,

Thanks for the quick reply. I am guessing it is not relevant to my case bec=
ause I am not using PERL. I cannot find anything that says PHP requires PER=
L so I suspect Iam ok in this regard.

Thank You,
Adam


-----Original Message-----
From: Edward Brookhouse [mailto:ebroo@healthydirections.com]=20
Sent: Wednesday, December 23, 2009 9:59 AM
To: Adam Sonzogni; php-db@lists.php.net
Subject: RE: Help for a beginner

Just a guess, as I have not tried a full stack in windows, but in any unix =
if you are connecting php and mysql, you need something in the middle like =
DBD::mysql

See if this helps: http://forums.mysql.com/read.php?51,189692,189856


-----Original Message-----
From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]=20
Sent: Wednesday, December 23, 2009 9:52 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Help for a beginner

Hi everyone, first thank you for ALL help and the understanding that I am n=
ew to PHP and MySQL. This is a long email and for that I apologize but I am=
trying to provide as much detail as possible. If this is the wrong list to=
ask for help, kindly direct me to the proper authority.

I am trying to learn and I have built the following environment.

Windows Server 2008 Standard 32bit service Pack 2 with IIS7
mysql-essential-5.1.41-win32
php-5.3.1-nts-Win32-VC9-x86.msi
phpMyAdmin-3.2.4-english.zip


I followed the steps as detailed below (I already had IIS7 and CGI installe=
d)


1. Install CGI & PHP
http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/

2. Install MySQL
http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
=20
3. Install PHPMyAdmin
http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server=
-2008/2008-09-16/


After I completed the installations
1. If I navigate to the PHP directory and type php -info it spews a ton of =
data at me
AND
I created info.php which contains:
When I browse this, it correctly produces a page with all the info about=
my PHP server. Although I do not understand much of it I believe this conf=
irms PHP is working correctly with IIS

2. I open the MySQL CLI and perform the commands outlined in Step 23 at thi=
s page
http://www.bicubica.com/apache-php-mysql/index.php
This returns the expected results, confirming MySQL is working

3. PHP is configured to work with php_mysql.dll as per the steps in the tra=
insignal links above so I begin!
I go to the phpmyadmin page, enter root and my password and after a long ti=
me I get a FastCGI error. I am not ready to believe it because, in classic =
MS form, it has several VERY different potential causes, and I have covered=
all of those. Plus the error code is 0x00000000 which is like saying nothi=
ng... I start thinking maybe it is not connecting to the mYSQL server right=
, the instructions re: pma and the password made no sense to me so I fiddle=
with that with no change.


I write the mysql_test.php page in step 5 of http://www.bicubica.com/ap=
ache-php-mysql/index.php
This fails with: A connection attempt failed because the connected party=
did not properly respond after a period of time, or established connection=
failed because connected host has failed to respond.

Because the PHP failed I try with ASP...
<%
set conn=3DServer.CreateObject("ADODB.Connection")
conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3D=
test;User Id=3Droot;Password=3Dyouwish"
conn.open
Response.write("Connected")
conn.close
%>

This returns:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20
[Microsoft][ODBC Driver Manager] Data source name not found and no d=
efault driver specified=20
/test.asp, line 4

I believe I have established MySQL is working, but for some reason it appea=
rs that it cannot be "reached" This IS on the same server so firewall shoul=
d not be an issue, PLUS I confirmed the installer did create a hole. I turn=
off the MS firewall to be safe, no change.... I try a "repair" of MySQL, I=
uninstall, reboot and reinstall with no change.

NOTE: at several points I have tried iisreset and/or rebooting the system w=
ith no change.

I start to research the matter and my mind is now unglued. I found somethin=
g referencing using mcrypt with PHPMyAdmin to speed it up and wondered if m=
aybe the long delay before the FastCGI error could be resolved so I tracked=
down the dll, put it in my ext directory and changed my php.ini to reflect=
this -- file found at http://files.edin.dk/php/win32/mcrypt/

I found quite a bit about using libmysql.dll but there was no such file in =
my install, I pulled down the .zip package and that also did not contain it=
, I eventually found it in a 5.2.x archive but that does not seem to have h=
elped. I have tried enabling: only mysql, mysql AND mysqli, and only mysqli=
.. None of this seems to have done anything to change my situation.

Again, I apologize for the lengthy message, I hope I have accurately descri=
bed my issue in the right amount of detail.

Thank You!
Adam Sonzogni




=20

--=20
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: RE: Help for a beginner

--0016367657ad580e46047b66d0e4
Content-Type: text/plain; charset=UTF-8

why dont u install the xampp....

On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni wrote:

> Mr. Brookhouse,
>
> Thanks for the quick reply. I am guessing it is not relevant to my case
> because I am not using PERL. I cannot find anything that says PHP requires
> PERL so I suspect Iam ok in this regard.
>
> Thank You,
> Adam
>
>
> -----Original Message-----
> From: Edward Brookhouse [mailto:ebroo@healthydirections.com]
> Sent: Wednesday, December 23, 2009 9:59 AM
> To: Adam Sonzogni; php-db@lists.php.net
> Subject: RE: Help for a beginner
>
> Just a guess, as I have not tried a full stack in windows, but in any unix
> if you are connecting php and mysql, you need something in the middle like
> DBD::mysql
>
> See if this helps: http://forums.mysql.com/read.php?51,189692,189856
>
>
> -----Original Message-----
> From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]
> Sent: Wednesday, December 23, 2009 9:52 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Help for a beginner
>
> Hi everyone, first thank you for ALL help and the understanding that I am
> new to PHP and MySQL. This is a long email and for that I apologize but I am
> trying to provide as much detail as possible. If this is the wrong list to
> ask for help, kindly direct me to the proper authority.
>
> I am trying to learn and I have built the following environment.
>
> Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> mysql-essential-5.1.41-win32
> php-5.3.1-nts-Win32-VC9-x86.msi
> phpMyAdmin-3.2.4-english.zip
>
>
> I followed the steps as detailed below (I already had IIS7 and CGI
> installed)
>
>
> 1. Install CGI & PHP
> http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
>
> 2. Install MySQL
> http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
>
> 3. Install PHPMyAdmin
>
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-2008/2008-09-16/
>
>
> After I completed the installations
> 1. If I navigate to the PHP directory and type php -info it spews a ton of
> data at me
> AND
> I created info.php which contains:
> When I browse this, it correctly produces a page with all the info about
> my PHP server. Although I do not understand much of it I believe this
> confirms PHP is working correctly with IIS
>
> 2. I open the MySQL CLI and perform the commands outlined in Step 23 at
> this page
> http://www.bicubica.com/apache-php-mysql/index.php
> This returns the expected results, confirming MySQL is working
>
> 3. PHP is configured to work with php_mysql.dll as per the steps in the
> trainsignal links above so I begin!
> I go to the phpmyadmin page, enter root and my password and after a long
> time I get a FastCGI error. I am not ready to believe it because, in classic
> MS form, it has several VERY different potential causes, and I have covered
> all of those. Plus the error code is 0x00000000 which is like saying
> nothing... I start thinking maybe it is not connecting to the mYSQL server
> right, the instructions re: pma and the password made no sense to me so I
> fiddle with that with no change.
>
>
> I write the mysql_test.php page in step 5 of
> http://www.bicubica.com/apache-php-mysql/index.php
> This fails with: A connection attempt failed because the connected party
> did not properly respond after a period of time, or established connection
> failed because connected host has failed to respond.
>
> Because the PHP failed I try with ASP...
> <%
> set conn=Server.CreateObject("ADODB.Connection")
> conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User
> Id=root;Password=youwish"
> conn.open
> Response.write("Connected")
> conn.close
> %>
>
> This returns:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> /test.asp, line 4
>
> I believe I have established MySQL is working, but for some reason it
> appears that it cannot be "reached" This IS on the same server so firewall
> should not be an issue, PLUS I confirmed the installer did create a hole. I
> turn off the MS firewall to be safe, no change.... I try a "repair" of
> MySQL, I uninstall, reboot and reinstall with no change.
>
> NOTE: at several points I have tried iisreset and/or rebooting the system
> with no change.
>
> I start to research the matter and my mind is now unglued. I found
> something referencing using mcrypt with PHPMyAdmin to speed it up and
> wondered if maybe the long delay before the FastCGI error could be resolved
> so I tracked down the dll, put it in my ext directory and changed my php.ini
> to reflect this -- file found at http://files.edin.dk/php/win32/mcrypt/
>
> I found quite a bit about using libmysql.dll but there was no such file in
> my install, I pulled down the .zip package and that also did not contain it,
> I eventually found it in a 5.2.x archive but that does not seem to have
> helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> mysqli. None of this seems to have done anything to change my situation.
>
> Again, I apologize for the lengthy message, I hope I have accurately
> described my issue in the right amount of detail.
>
> Thank You!
> Adam Sonzogni
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--
Chaitanya

--0016367657ad580e46047b66d0e4--

Re: RE: Help for a beginner

It looks like you are not connecting because of a user name/password
combination. Typically, Windows does not use root as a valid login as do
most other operating systems. Try using your login information to see if
you can connect to mySQL using the GUI. I suspect you'll succeed. The
other option would be to use the mySQL admin user name and password. One
of those should work.

Once you can connect to your database with the GUI, you can then use PHP
to call the mySQL database connect strings and manipulate your data as
necessary. The DBD/DBI is a more generic solution that allows you to use
a standard coding structure in PHP (or perl) and easily change databases
underneath. For a small implementation, this isn't necessary. There are
other database abstraction layers that perform the same function.

Giff

On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> why dont u install the xampp....
>
> On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni wrote:
>
> > Mr. Brookhouse,
> >
> > Thanks for the quick reply. I am guessing it is not relevant to my case
> > because I am not using PERL. I cannot find anything that says PHP requires
> > PERL so I suspect Iam ok in this regard.
> >
> > Thank You,
> > Adam
> >
> >
> > -----Original Message-----
> > From: Edward Brookhouse [mailto:ebroo@healthydirections.com]
> > Sent: Wednesday, December 23, 2009 9:59 AM
> > To: Adam Sonzogni; php-db@lists.php.net
> > Subject: RE: Help for a beginner
> >
> > Just a guess, as I have not tried a full stack in windows, but in any unix
> > if you are connecting php and mysql, you need something in the middle like
> > DBD::mysql
> >
> > See if this helps: http://forums.mysql.com/read.php?51,189692,189856
> >
> >
> > -----Original Message-----
> > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]
> > Sent: Wednesday, December 23, 2009 9:52 AM
> > To: php-db@lists.php.net
> > Subject: [PHP-DB] Help for a beginner
> >
> > Hi everyone, first thank you for ALL help and the understanding that I am
> > new to PHP and MySQL. This is a long email and for that I apologize but I am
> > trying to provide as much detail as possible. If this is the wrong list to
> > ask for help, kindly direct me to the proper authority.
> >
> > I am trying to learn and I have built the following environment.
> >
> > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > mysql-essential-5.1.41-win32
> > php-5.3.1-nts-Win32-VC9-x86.msi
> > phpMyAdmin-3.2.4-english.zip
> >
> >
> > I followed the steps as detailed below (I already had IIS7 and CGI
> > installed)
> >
> >
> > 1. Install CGI & PHP
> > http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
> >
> > 2. Install MySQL
> > http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
> >
> > 3. Install PHPMyAdmin
> >
> > http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-2008/2008-09-16/
> >
> >
> > After I completed the installations
> > 1. If I navigate to the PHP directory and type php -info it spews a ton of
> > data at me
> > AND
> > I created info.php which contains:
> > When I browse this, it correctly produces a page with all the info about
> > my PHP server. Although I do not understand much of it I believe this
> > confirms PHP is working correctly with IIS
> >
> > 2. I open the MySQL CLI and perform the commands outlined in Step 23 at
> > this page
> > http://www.bicubica.com/apache-php-mysql/index.php
> > This returns the expected results, confirming MySQL is working
> >
> > 3. PHP is configured to work with php_mysql.dll as per the steps in the
> > trainsignal links above so I begin!
> > I go to the phpmyadmin page, enter root and my password and after a long
> > time I get a FastCGI error. I am not ready to believe it because, in classic
> > MS form, it has several VERY different potential causes, and I have covered
> > all of those. Plus the error code is 0x00000000 which is like saying
> > nothing... I start thinking maybe it is not connecting to the mYSQL server
> > right, the instructions re: pma and the password made no sense to me so I
> > fiddle with that with no change.
> >
> >
> > I write the mysql_test.php page in step 5 of
> > http://www.bicubica.com/apache-php-mysql/index.php
> > This fails with: A connection attempt failed because the connected party
> > did not properly respond after a period of time, or established connection
> > failed because connected host has failed to respond.
> >
> > Because the PHP failed I try with ASP...
> > <%
> > set conn=Server.CreateObject("ADODB.Connection")
> > conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User
> > Id=root;Password=youwish"
> > conn.open
> > Response.write("Connected")
> > conn.close
> > %>
> >
> > This returns:
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > [Microsoft][ODBC Driver Manager] Data source name not found and no
> > default driver specified
> > /test.asp, line 4
> >
> > I believe I have established MySQL is working, but for some reason it
> > appears that it cannot be "reached" This IS on the same server so firewall
> > should not be an issue, PLUS I confirmed the installer did create a hole. I
> > turn off the MS firewall to be safe, no change.... I try a "repair" of
> > MySQL, I uninstall, reboot and reinstall with no change.
> >
> > NOTE: at several points I have tried iisreset and/or rebooting the system
> > with no change.
> >
> > I start to research the matter and my mind is now unglued. I found
> > something referencing using mcrypt with PHPMyAdmin to speed it up and
> > wondered if maybe the long delay before the FastCGI error could be resolved
> > so I tracked down the dll, put it in my ext directory and changed my php.ini
> > to reflect this -- file found at http://files.edin.dk/php/win32/mcrypt/
> >
> > I found quite a bit about using libmysql.dll but there was no such file in
> > my install, I pulled down the .zip package and that also did not contain it,
> > I eventually found it in a 5.2.x archive but that does not seem to have
> > helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> > mysqli. None of this seems to have done anything to change my situation.
> >
> > Again, I apologize for the lengthy message, I hope I have accurately
> > described my issue in the right amount of detail.
> >
> > Thank You!
> > Adam Sonzogni
> >
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: RE: Help for a beginner

--_000_B1444D4F8602BF469416C025FC361DB501BA703046BAsfexchang es_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

Q2hhaXRhbnlhLA0KDQpBcGFjaGUgaXMgbm90IGFuIG9wdGlvbiBmb3IgdXMs IGFuZCBJSVMgaXMg
c2VydmluZyBQSFAgd2l0aG91dCBpc3N1ZSwgc28gSSB3b3VsZCBwcmVmZXIg dG8gcmVzb2x2ZSBt
eSBjb25uZWN0aXZpdHkgaXNzdWUuDQoNClRoYW5rcywNCkFkYW0NCg0KRnJv bTogQ2hhaXRhbnlh
IFlhbmFtYWRhbGEgW21haWx0bzpkci52aXJ1cy5pbmRpYUBnbWFpbC5jb21d DQpTZW50OiBXZWRu
ZXNkYXksIERlY2VtYmVyIDIzLCAyMDA5IDEwOjE3IEFNDQpUbzogQWRhbSBT b256b2duaQ0KQ2M6
IEVkd2FyZCBCcm9va2hvdXNlOyBwaHAtZGJAbGlzdHMucGhwLm5ldA0KU3Vi amVjdDogUmU6IFtQ
SFAtREJdIFJFOiBIZWxwIGZvciBhIGJlZ2lubmVyDQoNCndoeSBkb250IHUg aW5zdGFsbCB0aGUg
eGFtcHAuLi4uDQpPbiBXZWQsIERlYyAyMywgMjAwOSBhdCA4OjM4IFBNLCBB ZGFtIFNvbnpvZ25p
IDxhc29uem9nbmlAc2V0Zm9jdXMuY29tPG1haWx0bzphc29uem9nbmlAc2V0 Zm9jdXMuY29tPj4g
d3JvdGU6DQpNci4gQnJvb2tob3VzZSwNCg0KVGhhbmtzIGZvciB0aGUgcXVp Y2sgcmVwbHkuIEkg
YW0gZ3Vlc3NpbmcgaXQgaXMgbm90IHJlbGV2YW50IHRvIG15IGNhc2UgYmVj YXVzZSBJIGFtIG5v
dCB1c2luZyBQRVJMLiBJIGNhbm5vdCBmaW5kIGFueXRoaW5nIHRoYXQgc2F5 cyBQSFAgcmVxdWly
ZXMgUEVSTCBzbyBJIHN1c3BlY3QgSWFtIG9rIGluIHRoaXMgcmVnYXJkLg0K DQpUaGFuayBZb3Us
DQpBZGFtDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206 IEVkd2FyZCBCcm9v
a2hvdXNlIFttYWlsdG86ZWJyb29AaGVhbHRoeWRpcmVjdGlvbnMuY29tPG1h aWx0bzplYnJvb0Bo
ZWFsdGh5ZGlyZWN0aW9ucy5jb20+XQ0KU2VudDogV2VkbmVzZGF5LCBEZWNl bWJlciAyMywgMjAw
OSA5OjU5IEFNDQpUbzogQWRhbSBTb256b2duaTsgcGhwLWRiQGxpc3RzLnBo cC5uZXQ8bWFpbHRv
OnBocC1kYkBsaXN0cy5waHAubmV0Pg0KU3ViamVjdDogUkU6IEhlbHAgZm9y IGEgYmVnaW5uZXIN
Cg0KSnVzdCBhIGd1ZXNzLCBhcyBJIGhhdmUgbm90IHRyaWVkIGEgZnVsbCBz dGFjayBpbiB3aW5k
b3dzLCBidXQgaW4gYW55IHVuaXggaWYgeW91IGFyZSBjb25uZWN0aW5nIHBo cCBhbmQgbXlzcWws
IHlvdSBuZWVkIHNvbWV0aGluZyBpbiB0aGUgbWlkZGxlIGxpa2UgREJEOjpt eXNxbA0KDQpTZWUg
aWYgdGhpcyBoZWxwczogaHR0cDovL2ZvcnVtcy5teXNxbC5jb20vcmVhZC5w aHA/NTEsMTg5Njky
LDE4OTg1Ng0KDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9t OiBBZGFtIFNvbnpv
Z25pIFttYWlsdG86YXNvbnpvZ25pQFNldEZvY3VzLmNvbTxtYWlsdG86YXNv bnpvZ25pQFNldEZv
Y3VzLmNvbT5dDQpTZW50OiBXZWRuZXNkYXksIERlY2VtYmVyIDIzLCAyMDA5 IDk6NTIgQU0NClRv
OiBwaHAtZGJAbGlzdHMucGhwLm5ldDxtYWlsdG86cGhwLWRiQGxpc3RzLnBo cC5uZXQ+DQpTdWJq
ZWN0OiBbUEhQLURCXSBIZWxwIGZvciBhIGJlZ2lubmVyDQoNCkhpIGV2ZXJ5 b25lLCBmaXJzdCB0
aGFuayB5b3UgZm9yIEFMTCBoZWxwIGFuZCB0aGUgdW5kZXJzdGFuZGluZyB0 aGF0IEkgYW0gbmV3
IHRvIFBIUCBhbmQgTXlTUUwuIFRoaXMgaXMgYSBsb25nIGVtYWlsIGFuZCBm b3IgdGhhdCBJIGFw
b2xvZ2l6ZSBidXQgSSBhbSB0cnlpbmcgdG8gcHJvdmlkZSBhcyBtdWNoIGRl dGFpbCBhcyBwb3Nz
aWJsZS4gSWYgdGhpcyBpcyB0aGUgd3JvbmcgbGlzdCB0byBhc2sgZm9yIGhl bHAsIGtpbmRseSBk
aXJlY3QgbWUgdG8gdGhlIHByb3BlciBhdXRob3JpdHkuDQoNCkkgYW0gdHJ5 aW5nIHRvIGxlYXJu
IGFuZCBJIGhhdmUgYnVpbHQgdGhlIGZvbGxvd2luZyBlbnZpcm9ubWVudC4N Cg0KV2luZG93cyBT
ZXJ2ZXIgMjAwOCBTdGFuZGFyZCAzMmJpdCBzZXJ2aWNlIFBhY2sgMiB3aXRo IElJUzcNCm15c3Fs
LWVzc2VudGlhbC01LjEuNDEtd2luMzINCnBocC01LjMuMS1udHMtV2luMzIt VkM5LXg4Ni5tc2kN
CnBocE15QWRtaW4tMy4yLjQtZW5nbGlzaC56aXANCg0KDQpJIGZvbGxvd2Vk IHRoZSBzdGVwcyBh
cyBkZXRhaWxlZCBiZWxvdyAoSSBhbHJlYWR5IGhhZCBJSVM3IGFuZCBDR0kg aW5zdGFsbGVkKQ0K
DQoNCjEuIEluc3RhbGwgQ0dJICYgUEhQDQogIGh0dHA6Ly93d3cudHJhaW5z aWduYWx0cmFpbmlu
Zy5jb20vaWlzLTctaW5zdGFsbC1mYXN0Y2dpLXBocC8yMDA4LTA5LTA0Lw0K DQoyLiBJbnN0YWxs
IE15U1FMDQogIGh0dHA6Ly93d3cudHJhaW5zaWduYWx0cmFpbmluZy5jb20v aW5zdGFsbC1teXNx
bC1vbi1paXM3LzIwMDgtMDktMTAvDQoNCjMuIEluc3RhbGwgUEhQTXlBZG1p bg0KICBodHRwOi8v
d3d3LnRyYWluc2lnbmFsdHJhaW5pbmcuY29tL2luc3RhbGwtcGhwbXlhZG1p bi1vbi1paXM3LWFu
ZC1zZXJ2ZXItMjAwOC8yMDA4LTA5LTE2Lw0KDQoNCkFmdGVyIEkgY29tcGxl dGVkIHRoZSBpbnN0
YWxsYXRpb25zDQoxLiBJZiBJIG5hdmlnYXRlIHRvIHRoZSBQSFAgZGlyZWN0 b3J5IGFuZCB0eXBl
IHBocCAtaW5mbyBpdCBzcGV3cyBhIHRvbiBvZiBkYXRhIGF0IG1lDQogIEFO RA0KICBJIGNyZWF0
ZWQgaW5mby5waHAgd2hpY2ggY29udGFpbnM6ICAgICA8P3BocCBwaHBpbmZv KCk7ID8+DQogIFdo
ZW4gSSBicm93c2UgdGhpcywgaXQgY29ycmVjdGx5IHByb2R1Y2VzIGEgcGFn ZSB3aXRoIGFsbCB0
aGUgaW5mbyBhYm91dCBteSBQSFAgc2VydmVyLiBBbHRob3VnaCBJIGRvIG5v dCB1bmRlcnN0YW5k
IG11Y2ggb2YgaXQgSSBiZWxpZXZlIHRoaXMgY29uZmlybXMgUEhQIGlzIHdv cmtpbmcgY29ycmVj
dGx5IHdpdGggSUlTDQoNCjIuIEkgb3BlbiB0aGUgTXlTUUwgQ0xJIGFuZCBw ZXJmb3JtIHRoZSBj
b21tYW5kcyBvdXRsaW5lZCBpbiBTdGVwIDIzIGF0IHRoaXMgcGFnZQ0KICBo dHRwOi8vd3d3LmJp
Y3ViaWNhLmNvbS9hcGFjaGUtcGhwLW15c3FsL2luZGV4LnBocA0KICBUaGlz IHJldHVybnMgdGhl
IGV4cGVjdGVkIHJlc3VsdHMsIGNvbmZpcm1pbmcgTXlTUUwgaXMgd29ya2lu Zw0KDQozLiBQSFAg
aXMgY29uZmlndXJlZCB0byB3b3JrIHdpdGggcGhwX215c3FsLmRsbCBhcyBw ZXIgdGhlIHN0ZXBz
IGluIHRoZSB0cmFpbnNpZ25hbCBsaW5rcyBhYm92ZSBzbyBJIGJlZ2luIQ0K SSBnbyB0byB0aGUg
cGhwbXlhZG1pbiBwYWdlLCBlbnRlciByb290IGFuZCBteSBwYXNzd29yZCBh bmQgYWZ0ZXIgYSBs
b25nIHRpbWUgSSBnZXQgYSBGYXN0Q0dJIGVycm9yLiBJIGFtIG5vdCByZWFk eSB0byBiZWxpZXZl
IGl0IGJlY2F1c2UsIGluIGNsYXNzaWMgTVMgZm9ybSwgaXQgaGFzIHNldmVy YWwgVkVSWSBkaWZm
ZXJlbnQgcG90ZW50aWFsIGNhdXNlcywgYW5kIEkgaGF2ZSBjb3ZlcmVkIGFs bCBvZiB0aG9zZS4g
UGx1cyB0aGUgZXJyb3IgY29kZSBpcyAweDAwMDAwMDAwIHdoaWNoIGlzIGxp a2Ugc2F5aW5nIG5v
dGhpbmcuLi4gSSBzdGFydCB0aGlua2luZyBtYXliZSBpdCBpcyBub3QgY29u bmVjdGluZyB0byB0
aGUgbVlTUUwgc2VydmVyIHJpZ2h0LCB0aGUgaW5zdHJ1Y3Rpb25zIHJlOiBw bWEgYW5kIHRoZSBw
YXNzd29yZCBtYWRlIG5vIHNlbnNlIHRvIG1lIHNvIEkgZmlkZGxlIHdpdGgg dGhhdCB3aXRoIG5v
IGNoYW5nZS4NCg0KDQogIEkgIHdyaXRlIHRoZSBteXNxbF90ZXN0LnBocCBw YWdlIGluIHN0ZXAg
NSBvZiBodHRwOi8vd3d3LmJpY3ViaWNhLmNvbS9hcGFjaGUtcGhwLW15c3Fs L2luZGV4LnBocA0K
ICBUaGlzIGZhaWxzIHdpdGg6IEEgY29ubmVjdGlvbiBhdHRlbXB0IGZhaWxl ZCBiZWNhdXNlIHRo
ZSBjb25uZWN0ZWQgcGFydHkgZGlkIG5vdCBwcm9wZXJseSByZXNwb25kIGFm dGVyIGEgcGVyaW9k
IG9mIHRpbWUsIG9yIGVzdGFibGlzaGVkIGNvbm5lY3Rpb24gZmFpbGVkIGJl Y2F1c2UgY29ubmVj
dGVkIGhvc3QgaGFzIGZhaWxlZCB0byByZXNwb25kLg0KDQogIEJlY2F1c2Ug dGhlIFBIUCBmYWls
ZWQgSSB0cnkgd2l0aCBBU1AuLi4NCiAgPCUNCiAgc2V0IGNvbm49U2VydmVy LkNyZWF0ZU9iamVj
dCgiQURPREIuQ29ubmVjdGlvbiIpDQogIGNvbm4uQ29ubmVjdGlvblN0cmlu Zz0iRHJpdmVyPXtt
eVNRTH07U2VydmVyPWxvY2FsaG9zdDtEYXRhYmFzZT10ZXN0O1VzZXIgSWQ9 cm9vdDtQYXNzd29y
ZD15b3V3aXNoIg0KICBjb25uLm9wZW4NCiAgUmVzcG9uc2Uud3JpdGUoIkNv bm5lY3RlZCIpDQog
IGNvbm4uY2xvc2UNCiAgJT4NCg0KICBUaGlzIHJldHVybnM6DQogICAgICBN aWNyb3NvZnQgT0xF
IERCIFByb3ZpZGVyIGZvciBPREJDIERyaXZlcnMgZXJyb3IgJzgwMDA0MDA1 Jw0KICAgICAgW01p
Y3Jvc29mdF1bT0RCQyBEcml2ZXIgTWFuYWdlcl0gRGF0YSBzb3VyY2UgbmFt ZSBub3QgZm91bmQg
YW5kIG5vIGRlZmF1bHQgZHJpdmVyIHNwZWNpZmllZA0KICAgICAgL3Rlc3Qu YXNwLCBsaW5lIDQN
Cg0KSSBiZWxpZXZlIEkgaGF2ZSBlc3RhYmxpc2hlZCBNeVNRTCBpcyB3b3Jr aW5nLCBidXQgZm9y
IHNvbWUgcmVhc29uIGl0IGFwcGVhcnMgdGhhdCBpdCBjYW5ub3QgYmUgInJl YWNoZWQiIFRoaXMg
SVMgb24gdGhlIHNhbWUgc2VydmVyIHNvIGZpcmV3YWxsIHNob3VsZCBub3Qg YmUgYW4gaXNzdWUs
IFBMVVMgSSBjb25maXJtZWQgdGhlIGluc3RhbGxlciBkaWQgY3JlYXRlIGEg aG9sZS4gSSB0dXJu
IG9mZiB0aGUgTVMgZmlyZXdhbGwgdG8gYmUgc2FmZSwgbm8gY2hhbmdlLi4u LiBJIHRyeSBhICJy
ZXBhaXIiIG9mIE15U1FMLCBJIHVuaW5zdGFsbCwgcmVib290IGFuZCByZWlu c3RhbGwgd2l0aCBu
byBjaGFuZ2UuDQoNCk5PVEU6IGF0IHNldmVyYWwgcG9pbnRzIEkgaGF2ZSB0 cmllZCBpaXNyZXNl
dCBhbmQvb3IgcmVib290aW5nIHRoZSBzeXN0ZW0gd2l0aCBubyBjaGFuZ2Uu DQoNCkkgc3RhcnQg
dG8gcmVzZWFyY2ggdGhlIG1hdHRlciBhbmQgbXkgbWluZCBpcyBub3cgdW5n bHVlZC4gSSBmb3Vu
ZCBzb21ldGhpbmcgcmVmZXJlbmNpbmcgdXNpbmcgbWNyeXB0IHdpdGggUEhQ TXlBZG1pbiB0byBz
cGVlZCBpdCB1cCBhbmQgd29uZGVyZWQgaWYgbWF5YmUgdGhlIGxvbmcgZGVs YXkgYmVmb3JlIHRo
ZSBGYXN0Q0dJIGVycm9yIGNvdWxkIGJlIHJlc29sdmVkIHNvIEkgdHJhY2tl ZCBkb3duIHRoZSBk
bGwsIHB1dCBpdCBpbiBteSBleHQgZGlyZWN0b3J5IGFuZCBjaGFuZ2VkIG15 IHBocC5pbmkgdG8g
cmVmbGVjdCB0aGlzIC0tIGZpbGUgZm91bmQgYXQgaHR0cDovL2ZpbGVzLmVk aW4uZGsvcGhwL3dp
bjMyL21jcnlwdC8NCg0KSSBmb3VuZCBxdWl0ZSBhIGJpdCBhYm91dCB1c2lu ZyBsaWJteXNxbC5k
bGwgYnV0IHRoZXJlIHdhcyBubyBzdWNoIGZpbGUgaW4gbXkgaW5zdGFsbCwg SSBwdWxsZWQgZG93
biB0aGUgLnppcCBwYWNrYWdlIGFuZCB0aGF0IGFsc28gZGlkIG5vdCBjb250 YWluIGl0LCBJIGV2
ZW50dWFsbHkgZm91bmQgaXQgaW4gYSA1LjIueCBhcmNoaXZlIGJ1dCB0aGF0 IGRvZXMgbm90IHNl
ZW0gdG8gaGF2ZSBoZWxwZWQuIEkgaGF2ZSB0cmllZCBlbmFibGluZzogb25s eSBteXNxbCwgbXlz
cWwgQU5EIG15c3FsaSwgYW5kIG9ubHkgbXlzcWxpLiBOb25lIG9mIHRoaXMg c2VlbXMgdG8gaGF2
ZSBkb25lIGFueXRoaW5nIHRvIGNoYW5nZSBteSBzaXR1YXRpb24uDQoNCkFn YWluLCBJIGFwb2xv
Z2l6ZSBmb3IgdGhlIGxlbmd0aHkgbWVzc2FnZSwgSSBob3BlIEkgaGF2ZSBh Y2N1cmF0ZWx5IGRl
c2NyaWJlZCBteSBpc3N1ZSBpbiB0aGUgcmlnaHQgYW1vdW50IG9mIGRldGFp bC4NCg0KVGhhbmsg
WW91IQ0KQWRhbSBTb256b2duaQ0KDQoNCg0KDQoNCg0KLS0NClBIUCBEYXRh YmFzZSBNYWlsaW5n
IExpc3QgKGh0dHA6Ly93d3cucGhwLm5ldC8pDQpUbyB1bnN1YnNjcmliZSwg dmlzaXQ6IGh0dHA6
Ly93d3cucGhwLm5ldC91bnN1Yi5waHANCg0KDQoNCg0KDQotLQ0KUEhQIERh dGFiYXNlIE1haWxp
bmcgTGlzdCAoaHR0cDovL3d3dy5waHAubmV0LykNClRvIHVuc3Vic2NyaWJl LCB2aXNpdDogaHR0
cDovL3d3dy5waHAubmV0L3Vuc3ViLnBocA0KDQoNCg0KLS0NCkNoYWl0YW55 YQ0KDQo=

--_000_B1444D4F8602BF469416C025FC361DB501BA703046BAsfexchang es_--

RE: RE: Help for a beginner

R2lmZiwNCg0KTm90IHN1cmUgd2hhdCB5b3UgbWVhbiwgYW5kIEkgc3VzcGVj dCB0aGlzIGlzIGJl
Y2F1c2Ugb2YgbXkgY29uZnVzaW9uIGFyb3VuZCBQTUEgKGFzIG1lbnRpb25l ZCBvcmlnaW5hbGx5
KSBTTyBsZXQgbWUgZWxhYm9yYXRlLi4uDQoNCg0KDQpJbiBteSBjb25maWcu aW5jLnBocCBJIGNo
YW5nZWQgcG1hIHRvIHJvb3QgYW5kIHRoZSBwbWEgcGFzc3dvcmQgdG8gdGhl IHJvb3QgcGFzc3dv
cmQgZm9yIG15c3FsDQpXaGVuIEkgYnJvd3NlIHRvIHRoZSBwaHBteWFkbWlu IHBhZ2UgSSBuZXRl
ciByb290IGFuZCB0aGUgcm9vdCBwYXNzd29yZCBmb3IgbXlzcWwNCg0KVGhh bmtzLA0KQWRhbQ0K
DQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogR2lmZiBIYW1t YXIgW21haWx0bzpn
aGFtbWFyQHN2LXBob2VuaXguY29tXSANClNlbnQ6IFdlZG5lc2RheSwgRGVj ZW1iZXIgMjMsIDIw
MDkgMTA6NDEgQU0NClRvOiBwaHAtZGJAbGlzdHMucGhwLm5ldA0KU3ViamVj dDogUmU6IFtQSFAt
REJdIFJFOiBIZWxwIGZvciBhIGJlZ2lubmVyDQoNCkl0IGxvb2tzIGxpa2Ug eW91IGFyZSBub3Qg
Y29ubmVjdGluZyBiZWNhdXNlIG9mIGEgdXNlciBuYW1lL3Bhc3N3b3JkDQpj b21iaW5hdGlvbi4g
VHlwaWNhbGx5LCBXaW5kb3dzIGRvZXMgbm90IHVzZSByb290IGFzIGEgdmFs aWQgbG9naW4gYXMg
ZG8NCm1vc3Qgb3RoZXIgb3BlcmF0aW5nIHN5c3RlbXMuIFRyeSB1c2luZyB5 b3VyIGxvZ2luIGlu
Zm9ybWF0aW9uIHRvIHNlZSBpZg0KeW91IGNhbiBjb25uZWN0IHRvIG15U1FM IHVzaW5nIHRoZSBH
VUkuIEkgc3VzcGVjdCB5b3UnbGwgc3VjY2VlZC4gVGhlDQpvdGhlciBvcHRp b24gd291bGQgYmUg
dG8gdXNlIHRoZSBteVNRTCBhZG1pbiB1c2VyIG5hbWUgYW5kIHBhc3N3b3Jk LiBPbmUNCm9mIHRo
b3NlIHNob3VsZCB3b3JrLg0KDQpPbmNlIHlvdSBjYW4gY29ubmVjdCB0byB5 b3VyIGRhdGFiYXNl
IHdpdGggdGhlIEdVSSwgeW91IGNhbiB0aGVuIHVzZSBQSFANCnRvIGNhbGwg dGhlIG15U1FMIGRh
dGFiYXNlIGNvbm5lY3Qgc3RyaW5ncyBhbmQgbWFuaXB1bGF0ZSB5b3VyIGRh dGEgYXMNCm5lY2Vz
c2FyeS4gVGhlIERCRC9EQkkgaXMgYSBtb3JlIGdlbmVyaWMgc29sdXRpb24g dGhhdCBhbGxvd3Mg
eW91IHRvIHVzZQ0KYSBzdGFuZGFyZCBjb2Rpbmcgc3RydWN0dXJlIGluIFBI UCAob3IgcGVybCkg
YW5kIGVhc2lseSBjaGFuZ2UgZGF0YWJhc2VzDQp1bmRlcm5lYXRoLiBGb3Ig YSBzbWFsbCBpbXBs
ZW1lbnRhdGlvbiwgdGhpcyBpc24ndCBuZWNlc3NhcnkuIFRoZXJlIGFyZQ0K b3RoZXIgZGF0YWJh
c2UgYWJzdHJhY3Rpb24gbGF5ZXJzIHRoYXQgcGVyZm9ybSB0aGUgc2FtZSBm dW5jdGlvbi4NCg0K
R2lmZg0KDQpPbiBXZWQsIDIwMDktMTItMjMgYXQgMjA6NDYgKzA1MzAsIENo YWl0YW55YSBZYW5h
bWFkYWxhIHdyb3RlOg0KPiB3aHkgZG9udCB1IGluc3RhbGwgdGhlIHhhbXBw Li4uLg0KPiANCj4g
T24gV2VkLCBEZWMgMjMsIDIwMDkgYXQgODozOCBQTSwgQWRhbSBTb256b2du aSA8YXNvbnpvZ25p
QHNldGZvY3VzLmNvbT53cm90ZToNCj4gDQo+ID4gTXIuIEJyb29raG91c2Us DQo+ID4NCj4gPiBU
aGFua3MgZm9yIHRoZSBxdWljayByZXBseS4gSSBhbSBndWVzc2luZyBpdCBp cyBub3QgcmVsZXZh
bnQgdG8gbXkgY2FzZQ0KPiA+IGJlY2F1c2UgSSBhbSBub3QgdXNpbmcgUEVS TC4gSSBjYW5ub3Qg
ZmluZCBhbnl0aGluZyB0aGF0IHNheXMgUEhQIHJlcXVpcmVzDQo+ID4gUEVS TCBzbyBJIHN1c3Bl
Y3QgSWFtIG9rIGluIHRoaXMgcmVnYXJkLg0KPiA+DQo+ID4gVGhhbmsgWW91 LA0KPiA+IEFkYW0N
Cj4gPg0KPiA+DQo+ID4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4g PiBGcm9tOiBFZHdh
cmQgQnJvb2tob3VzZSBbbWFpbHRvOmVicm9vQGhlYWx0aHlkaXJlY3Rpb25z LmNvbV0NCj4gPiBT
ZW50OiBXZWRuZXNkYXksIERlY2VtYmVyIDIzLCAyMDA5IDk6NTkgQU0NCj4g PiBUbzogQWRhbSBT
b256b2duaTsgcGhwLWRiQGxpc3RzLnBocC5uZXQNCj4gPiBTdWJqZWN0OiBS RTogSGVscCBmb3Ig
YSBiZWdpbm5lcg0KPiA+DQo+ID4gSnVzdCBhIGd1ZXNzLCBhcyBJIGhhdmUg bm90IHRyaWVkIGEg
ZnVsbCBzdGFjayBpbiB3aW5kb3dzLCBidXQgaW4gYW55IHVuaXgNCj4gPiBp ZiB5b3UgYXJlIGNv
bm5lY3RpbmcgcGhwIGFuZCBteXNxbCwgeW91IG5lZWQgc29tZXRoaW5nIGlu IHRoZSBtaWRkbGUg
bGlrZQ0KPiA+IERCRDo6bXlzcWwNCj4gPg0KPiA+IFNlZSBpZiB0aGlzIGhl bHBzOiBodHRwOi8v
Zm9ydW1zLm15c3FsLmNvbS9yZWFkLnBocD81MSwxODk2OTIsMTg5ODU2DQo+ ID4NCj4gPg0KPiA+
IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+ID4gRnJvbTogQWRhbSBT b256b2duaSBbbWFp
bHRvOmFzb256b2duaUBTZXRGb2N1cy5jb21dDQo+ID4gU2VudDogV2VkbmVz ZGF5LCBEZWNlbWJl
ciAyMywgMjAwOSA5OjUyIEFNDQo+ID4gVG86IHBocC1kYkBsaXN0cy5waHAu bmV0DQo+ID4gU3Vi
amVjdDogW1BIUC1EQl0gSGVscCBmb3IgYSBiZWdpbm5lcg0KPiA+DQo+ID4g SGkgZXZlcnlvbmUs
IGZpcnN0IHRoYW5rIHlvdSBmb3IgQUxMIGhlbHAgYW5kIHRoZSB1bmRlcnN0 YW5kaW5nIHRoYXQg
SSBhbQ0KPiA+IG5ldyB0byBQSFAgYW5kIE15U1FMLiBUaGlzIGlzIGEgbG9u ZyBlbWFpbCBhbmQg
Zm9yIHRoYXQgSSBhcG9sb2dpemUgYnV0IEkgYW0NCj4gPiB0cnlpbmcgdG8g cHJvdmlkZSBhcyBt
dWNoIGRldGFpbCBhcyBwb3NzaWJsZS4gSWYgdGhpcyBpcyB0aGUgd3Jvbmcg bGlzdCB0bw0KPiA+
IGFzayBmb3IgaGVscCwga2luZGx5IGRpcmVjdCBtZSB0byB0aGUgcHJvcGVy IGF1dGhvcml0eS4N
Cj4gPg0KPiA+IEkgYW0gdHJ5aW5nIHRvIGxlYXJuIGFuZCBJIGhhdmUgYnVp bHQgdGhlIGZvbGxv
d2luZyBlbnZpcm9ubWVudC4NCj4gPg0KPiA+IFdpbmRvd3MgU2VydmVyIDIw MDggU3RhbmRhcmQg
MzJiaXQgc2VydmljZSBQYWNrIDIgd2l0aCBJSVM3DQo+ID4gbXlzcWwtZXNz ZW50aWFsLTUuMS40
MS13aW4zMg0KPiA+IHBocC01LjMuMS1udHMtV2luMzItVkM5LXg4Ni5tc2kN Cj4gPiBwaHBNeUFk
bWluLTMuMi40LWVuZ2xpc2guemlwDQo+ID4NCj4gPg0KPiA+IEkgZm9sbG93 ZWQgdGhlIHN0ZXBz
IGFzIGRldGFpbGVkIGJlbG93IChJIGFscmVhZHkgaGFkIElJUzcgYW5kIENH SQ0KPiA+IGluc3Rh
bGxlZCkNCj4gPg0KPiA+DQo+ID4gMS4gSW5zdGFsbCBDR0kgJiBQSFANCj4g PiAgIGh0dHA6Ly93
d3cudHJhaW5zaWduYWx0cmFpbmluZy5jb20vaWlzLTctaW5zdGFsbC1mYXN0 Y2dpLXBocC8yMDA4
LTA5LTA0Lw0KPiA+DQo+ID4gMi4gSW5zdGFsbCBNeVNRTA0KPiA+ICAgaHR0 cDovL3d3dy50cmFp
bnNpZ25hbHRyYWluaW5nLmNvbS9pbnN0YWxsLW15c3FsLW9uLWlpczcvMjAw OC0wOS0xMC8NCj4g
Pg0KPiA+IDMuIEluc3RhbGwgUEhQTXlBZG1pbg0KPiA+DQo+ID4gaHR0cDov L3d3dy50cmFpbnNp
Z25hbHRyYWluaW5nLmNvbS9pbnN0YWxsLXBocG15YWRtaW4tb24taWlzNy1h bmQtc2VydmVyLTIw
MDgvMjAwOC0wOS0xNi8NCj4gPg0KPiA+DQo+ID4gQWZ0ZXIgSSBjb21wbGV0 ZWQgdGhlIGluc3Rh
bGxhdGlvbnMNCj4gPiAxLiBJZiBJIG5hdmlnYXRlIHRvIHRoZSBQSFAgZGly ZWN0b3J5IGFuZCB0
eXBlIHBocCAtaW5mbyBpdCBzcGV3cyBhIHRvbiBvZg0KPiA+IGRhdGEgYXQg bWUNCj4gPiAgIEFO
RA0KPiA+ICAgSSBjcmVhdGVkIGluZm8ucGhwIHdoaWNoIGNvbnRhaW5zOiAg ICAgPD9waHAgcGhw
aW5mbygpOyA/Pg0KPiA+ICAgV2hlbiBJIGJyb3dzZSB0aGlzLCBpdCBjb3Jy ZWN0bHkgcHJvZHVj
ZXMgYSBwYWdlIHdpdGggYWxsIHRoZSBpbmZvIGFib3V0DQo+ID4gbXkgUEhQ IHNlcnZlci4gQWx0
aG91Z2ggSSBkbyBub3QgdW5kZXJzdGFuZCBtdWNoIG9mIGl0IEkgYmVsaWV2 ZSB0aGlzDQo+ID4g
Y29uZmlybXMgUEhQIGlzIHdvcmtpbmcgY29ycmVjdGx5IHdpdGggSUlTDQo+ ID4NCj4gPiAyLiBJ
IG9wZW4gdGhlIE15U1FMIENMSSBhbmQgcGVyZm9ybSB0aGUgY29tbWFuZHMg b3V0bGluZWQgaW4g
U3RlcCAyMyBhdA0KPiA+IHRoaXMgcGFnZQ0KPiA+ICAgaHR0cDovL3d3dy5i aWN1YmljYS5jb20v
YXBhY2hlLXBocC1teXNxbC9pbmRleC5waHANCj4gPiAgIFRoaXMgcmV0dXJu cyB0aGUgZXhwZWN0
ZWQgcmVzdWx0cywgY29uZmlybWluZyBNeVNRTCBpcyB3b3JraW5nDQo+ID4N Cj4gPiAzLiBQSFAg
aXMgY29uZmlndXJlZCB0byB3b3JrIHdpdGggcGhwX215c3FsLmRsbCBhcyBw ZXIgdGhlIHN0ZXBz
IGluIHRoZQ0KPiA+IHRyYWluc2lnbmFsIGxpbmtzIGFib3ZlIHNvIEkgYmVn aW4hDQo+ID4gSSBn
byB0byB0aGUgcGhwbXlhZG1pbiBwYWdlLCBlbnRlciByb290IGFuZCBteSBw YXNzd29yZCBhbmQg
YWZ0ZXIgYSBsb25nDQo+ID4gdGltZSBJIGdldCBhIEZhc3RDR0kgZXJyb3Iu IEkgYW0gbm90IHJl
YWR5IHRvIGJlbGlldmUgaXQgYmVjYXVzZSwgaW4gY2xhc3NpYw0KPiA+IE1T IGZvcm0sIGl0IGhh
cyBzZXZlcmFsIFZFUlkgZGlmZmVyZW50IHBvdGVudGlhbCBjYXVzZXMsIGFu ZCBJIGhhdmUgY292
ZXJlZA0KPiA+IGFsbCBvZiB0aG9zZS4gUGx1cyB0aGUgZXJyb3IgY29kZSBp cyAweDAwMDAwMDAw
IHdoaWNoIGlzIGxpa2Ugc2F5aW5nDQo+ID4gbm90aGluZy4uLiBJIHN0YXJ0 IHRoaW5raW5nIG1h
eWJlIGl0IGlzIG5vdCBjb25uZWN0aW5nIHRvIHRoZSBtWVNRTCBzZXJ2ZXIN Cj4gPiByaWdodCwg
dGhlIGluc3RydWN0aW9ucyByZTogcG1hIGFuZCB0aGUgcGFzc3dvcmQgbWFk ZSBubyBzZW5zZSB0
byBtZSBzbyBJDQo+ID4gZmlkZGxlIHdpdGggdGhhdCB3aXRoIG5vIGNoYW5n ZS4NCj4gPg0KPiA+
DQo+ID4gICBJICB3cml0ZSB0aGUgbXlzcWxfdGVzdC5waHAgcGFnZSBpbiBz dGVwIDUgb2YNCj4g
PiBodHRwOi8vd3d3LmJpY3ViaWNhLmNvbS9hcGFjaGUtcGhwLW15c3FsL2lu ZGV4LnBocA0KPiA+
ICAgVGhpcyBmYWlscyB3aXRoOiBBIGNvbm5lY3Rpb24gYXR0ZW1wdCBmYWls ZWQgYmVjYXVzZSB0
aGUgY29ubmVjdGVkIHBhcnR5DQo+ID4gZGlkIG5vdCBwcm9wZXJseSByZXNw b25kIGFmdGVyIGEg
cGVyaW9kIG9mIHRpbWUsIG9yIGVzdGFibGlzaGVkIGNvbm5lY3Rpb24NCj4g PiBmYWlsZWQgYmVj
YXVzZSBjb25uZWN0ZWQgaG9zdCBoYXMgZmFpbGVkIHRvIHJlc3BvbmQuDQo+ ID4NCj4gPiAgIEJl
Y2F1c2UgdGhlIFBIUCBmYWlsZWQgSSB0cnkgd2l0aCBBU1AuLi4NCj4gPiAg IDwlDQo+ID4gICBz
ZXQgY29ubj1TZXJ2ZXIuQ3JlYXRlT2JqZWN0KCJBRE9EQi5Db25uZWN0aW9u IikNCj4gPiAgIGNv
bm4uQ29ubmVjdGlvblN0cmluZz0iRHJpdmVyPXtteVNRTH07U2VydmVyPWxv Y2FsaG9zdDtEYXRh
YmFzZT10ZXN0O1VzZXINCj4gPiBJZD1yb290O1Bhc3N3b3JkPXlvdXdpc2gi DQo+ID4gICBjb25u
Lm9wZW4NCj4gPiAgIFJlc3BvbnNlLndyaXRlKCJDb25uZWN0ZWQiKQ0KPiA+ ICAgY29ubi5jbG9z
ZQ0KPiA+ICAgJT4NCj4gPg0KPiA+ICAgVGhpcyByZXR1cm5zOg0KPiA+ICAg ICAgIE1pY3Jvc29m
dCBPTEUgREIgUHJvdmlkZXIgZm9yIE9EQkMgRHJpdmVycyBlcnJvciAnODAw MDQwMDUnDQo+ID4g
ICAgICAgW01pY3Jvc29mdF1bT0RCQyBEcml2ZXIgTWFuYWdlcl0gRGF0YSBz b3VyY2UgbmFtZSBu
b3QgZm91bmQgYW5kIG5vDQo+ID4gZGVmYXVsdCBkcml2ZXIgc3BlY2lmaWVk DQo+ID4gICAgICAg
L3Rlc3QuYXNwLCBsaW5lIDQNCj4gPg0KPiA+IEkgYmVsaWV2ZSBJIGhhdmUg ZXN0YWJsaXNoZWQg
TXlTUUwgaXMgd29ya2luZywgYnV0IGZvciBzb21lIHJlYXNvbiBpdA0KPiA+ IGFwcGVhcnMgdGhh
dCBpdCBjYW5ub3QgYmUgInJlYWNoZWQiIFRoaXMgSVMgb24gdGhlIHNhbWUg c2VydmVyIHNvIGZp
cmV3YWxsDQo+ID4gc2hvdWxkIG5vdCBiZSBhbiBpc3N1ZSwgUExVUyBJIGNv bmZpcm1lZCB0aGUg
aW5zdGFsbGVyIGRpZCBjcmVhdGUgYSBob2xlLiBJDQo+ID4gdHVybiBvZmYg dGhlIE1TIGZpcmV3
YWxsIHRvIGJlIHNhZmUsIG5vIGNoYW5nZS4uLi4gSSB0cnkgYSAicmVwYWly IiBvZg0KPiA+IE15
U1FMLCBJIHVuaW5zdGFsbCwgcmVib290IGFuZCByZWluc3RhbGwgd2l0aCBu byBjaGFuZ2UuDQo+
ID4NCj4gPiBOT1RFOiBhdCBzZXZlcmFsIHBvaW50cyBJIGhhdmUgdHJpZWQg aWlzcmVzZXQgYW5k
L29yIHJlYm9vdGluZyB0aGUgc3lzdGVtDQo+ID4gd2l0aCBubyBjaGFuZ2Uu DQo+ID4NCj4gPiBJ
IHN0YXJ0IHRvIHJlc2VhcmNoIHRoZSBtYXR0ZXIgYW5kIG15IG1pbmQgaXMg bm93IHVuZ2x1ZWQu
IEkgZm91bmQNCj4gPiBzb21ldGhpbmcgcmVmZXJlbmNpbmcgdXNpbmcgbWNy eXB0IHdpdGggUEhQ
TXlBZG1pbiB0byBzcGVlZCBpdCB1cCBhbmQNCj4gPiB3b25kZXJlZCBpZiBt YXliZSB0aGUgbG9u
ZyBkZWxheSBiZWZvcmUgdGhlIEZhc3RDR0kgZXJyb3IgY291bGQgYmUgcmVz b2x2ZWQNCj4gPiBz
byBJIHRyYWNrZWQgZG93biB0aGUgZGxsLCBwdXQgaXQgaW4gbXkgZXh0IGRp cmVjdG9yeSBhbmQg
Y2hhbmdlZCBteSBwaHAuaW5pDQo+ID4gdG8gcmVmbGVjdCB0aGlzIC0tIGZp bGUgZm91bmQgYXQg
aHR0cDovL2ZpbGVzLmVkaW4uZGsvcGhwL3dpbjMyL21jcnlwdC8NCj4gPg0K PiA+IEkgZm91bmQg
cXVpdGUgYSBiaXQgYWJvdXQgdXNpbmcgbGlibXlzcWwuZGxsIGJ1dCB0aGVy ZSB3YXMgbm8gc3Vj
aCBmaWxlIGluDQo+ID4gbXkgaW5zdGFsbCwgSSBwdWxsZWQgZG93biB0aGUg LnppcCBwYWNrYWdl
IGFuZCB0aGF0IGFsc28gZGlkIG5vdCBjb250YWluIGl0LA0KPiA+IEkgZXZl bnR1YWxseSBmb3Vu
ZCBpdCBpbiBhIDUuMi54IGFyY2hpdmUgYnV0IHRoYXQgZG9lcyBub3Qgc2Vl bSB0byBoYXZlDQo+
ID4gaGVscGVkLiBJIGhhdmUgdHJpZWQgZW5hYmxpbmc6IG9ubHkgbXlzcWws IG15c3FsIEFORCBt
eXNxbGksIGFuZCBvbmx5DQo+ID4gbXlzcWxpLiBOb25lIG9mIHRoaXMgc2Vl bXMgdG8gaGF2ZSBk
b25lIGFueXRoaW5nIHRvIGNoYW5nZSBteSBzaXR1YXRpb24uDQo+ID4NCj4g PiBBZ2FpbiwgSSBh
cG9sb2dpemUgZm9yIHRoZSBsZW5ndGh5IG1lc3NhZ2UsIEkgaG9wZSBJIGhh dmUgYWNjdXJhdGVs
eQ0KPiA+IGRlc2NyaWJlZCBteSBpc3N1ZSBpbiB0aGUgcmlnaHQgYW1vdW50 IG9mIGRldGFpbC4N
Cj4gPg0KPiA+IFRoYW5rIFlvdSENCj4gPiBBZGFtIFNvbnpvZ25pDQo+ID4N Cj4gPg0KPiA+DQo+
ID4NCj4gPg0KPiA+DQo+ID4gLS0NCj4gPiBQSFAgRGF0YWJhc2UgTWFpbGlu ZyBMaXN0IChodHRw
Oi8vd3d3LnBocC5uZXQvKQ0KPiA+IFRvIHVuc3Vic2NyaWJlLCB2aXNpdDog aHR0cDovL3d3dy5w
aHAubmV0L3Vuc3ViLnBocA0KPiA+DQo+ID4NCj4gPg0KPiA+DQo+ID4NCj4g PiAtLQ0KPiA+IFBI
UCBEYXRhYmFzZSBNYWlsaW5nIExpc3QgKGh0dHA6Ly93d3cucGhwLm5ldC8p DQo+ID4gVG8gdW5z
dWJzY3JpYmUsIHZpc2l0OiBodHRwOi8vd3d3LnBocC5uZXQvdW5zdWIucGhw DQo+ID4NCj4gPg0K
PiANCj4gDQoNCg0KDQotLSANClBIUCBEYXRhYmFzZSBNYWlsaW5nIExpc3Qg KGh0dHA6Ly93d3cu
cGhwLm5ldC8pDQpUbyB1bnN1YnNjcmliZSwgdmlzaXQ6IGh0dHA6Ly93d3cu cGhwLm5ldC91bnN1
Yi5waHANCg0K

Re: RE: Help for a beginner

--000e0cd139fec8fd27047b67cc32
Content-Type: text/plain; charset=ISO-8859-1

Adam,

What is at Line 4 in your test.asp? The error you provided said that there
was a problem where it could not find the default driver to use.

Also when you get the connection failed you were trying to connect to MYSQL
from the system running MYSQL correct?

On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni wrote:

> Giff,
>
> Not sure what you mean, and I suspect this is because of my confusion
> around PMA (as mentioned originally) SO let me elaborate...
>
>
>
> In my config.inc.php I changed pma to root and the pma password to the root
> password for mysql
> When I browse to the phpmyadmin page I neter root and the root password for
> mysql
>
> Thanks,
> Adam
>
> -----Original Message-----
> From: Giff Hammar [mailto:ghammar@sv-phoenix.com]
> Sent: Wednesday, December 23, 2009 10:41 AM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> It looks like you are not connecting because of a user name/password
> combination. Typically, Windows does not use root as a valid login as do
> most other operating systems. Try using your login information to see if
> you can connect to mySQL using the GUI. I suspect you'll succeed. The
> other option would be to use the mySQL admin user name and password. One
> of those should work.
>
> Once you can connect to your database with the GUI, you can then use PHP
> to call the mySQL database connect strings and manipulate your data as
> necessary. The DBD/DBI is a more generic solution that allows you to use
> a standard coding structure in PHP (or perl) and easily change databases
> underneath. For a small implementation, this isn't necessary. There are
> other database abstraction layers that perform the same function.
>
> Giff
>
> On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > why dont u install the xampp....
> >
> > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni > >wrote:
> >
> > > Mr. Brookhouse,
> > >
> > > Thanks for the quick reply. I am guessing it is not relevant to my case
> > > because I am not using PERL. I cannot find anything that says PHP
> requires
> > > PERL so I suspect Iam ok in this regard.
> > >
> > > Thank You,
> > > Adam
> > >
> > >
> > > -----Original Message-----
> > > From: Edward Brookhouse [mailto:ebroo@healthydirections.com]
> > > Sent: Wednesday, December 23, 2009 9:59 AM
> > > To: Adam Sonzogni; php-db@lists.php.net
> > > Subject: RE: Help for a beginner
> > >
> > > Just a guess, as I have not tried a full stack in windows, but in any
> unix
> > > if you are connecting php and mysql, you need something in the middle
> like
> > > DBD::mysql
> > >
> > > See if this helps: http://forums.mysql.com/read.php?51,189692,189856
> > >
> > >
> > > -----Original Message-----
> > > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]
> > > Sent: Wednesday, December 23, 2009 9:52 AM
> > > To: php-db@lists.php.net
> > > Subject: [PHP-DB] Help for a beginner
> > >
> > > Hi everyone, first thank you for ALL help and the understanding that I
> am
> > > new to PHP and MySQL. This is a long email and for that I apologize but
> I am
> > > trying to provide as much detail as possible. If this is the wrong list
> to
> > > ask for help, kindly direct me to the proper authority.
> > >
> > > I am trying to learn and I have built the following environment.
> > >
> > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > > mysql-essential-5.1.41-win32
> > > php-5.3.1-nts-Win32-VC9-x86.msi
> > > phpMyAdmin-3.2.4-english.zip
> > >
> > >
> > > I followed the steps as detailed below (I already had IIS7 and CGI
> > > installed)
> > >
> > >
> > > 1. Install CGI & PHP
> > >
> http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
> > >
> > > 2. Install MySQL
> > > http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
> > >
> > > 3. Install PHPMyAdmin
> > >
> > >
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-2008/2008-09-16/
> > >
> > >
> > > After I completed the installations
> > > 1. If I navigate to the PHP directory and type php -info it spews a ton
> of
> > > data at me
> > > AND
> > > I created info.php which contains:
> > > When I browse this, it correctly produces a page with all the info
> about
> > > my PHP server. Although I do not understand much of it I believe this
> > > confirms PHP is working correctly with IIS
> > >
> > > 2. I open the MySQL CLI and perform the commands outlined in Step 23 at
> > > this page
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This returns the expected results, confirming MySQL is working
> > >
> > > 3. PHP is configured to work with php_mysql.dll as per the steps in the
> > > trainsignal links above so I begin!
> > > I go to the phpmyadmin page, enter root and my password and after a
> long
> > > time I get a FastCGI error. I am not ready to believe it because, in
> classic
> > > MS form, it has several VERY different potential causes, and I have
> covered
> > > all of those. Plus the error code is 0x00000000 which is like saying
> > > nothing... I start thinking maybe it is not connecting to the mYSQL
> server
> > > right, the instructions re: pma and the password made no sense to me so
> I
> > > fiddle with that with no change.
> > >
> > >
> > > I write the mysql_test.php page in step 5 of
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This fails with: A connection attempt failed because the connected
> party
> > > did not properly respond after a period of time, or established
> connection
> > > failed because connected host has failed to respond.
> > >
> > > Because the PHP failed I try with ASP...
> > > <%
> > > set conn=Server.CreateObject("ADODB.Connection")
> > >
> conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User
> > > Id=root;Password=youwish"
> > > conn.open
> > > Response.write("Connected")
> > > conn.close
> > > %>
> > >
> > > This returns:
> > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > [Microsoft][ODBC Driver Manager] Data source name not found and
> no
> > > default driver specified
> > > /test.asp, line 4
> > >
> > > I believe I have established MySQL is working, but for some reason it
> > > appears that it cannot be "reached" This IS on the same server so
> firewall
> > > should not be an issue, PLUS I confirmed the installer did create a
> hole. I
> > > turn off the MS firewall to be safe, no change.... I try a "repair" of
> > > MySQL, I uninstall, reboot and reinstall with no change.
> > >
> > > NOTE: at several points I have tried iisreset and/or rebooting the
> system
> > > with no change.
> > >
> > > I start to research the matter and my mind is now unglued. I found
> > > something referencing using mcrypt with PHPMyAdmin to speed it up and
> > > wondered if maybe the long delay before the FastCGI error could be
> resolved
> > > so I tracked down the dll, put it in my ext directory and changed my
> php.ini
> > > to reflect this -- file found at
> http://files.edin.dk/php/win32/mcrypt/
> > >
> > > I found quite a bit about using libmysql.dll but there was no such file
> in
> > > my install, I pulled down the .zip package and that also did not
> contain it,
> > > I eventually found it in a 5.2.x archive but that does not seem to have
> > > helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> > > mysqli. None of this seems to have done anything to change my
> situation.
> > >
> > > Again, I apologize for the lengthy message, I hope I have accurately
> > > described my issue in the right amount of detail.
> > >
> > > Thank You!
> > > Adam Sonzogni
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--

height="31">

--000e0cd139fec8fd27047b67cc32--

RE: RE: Help for a beginner

Barry,

Yes this is all installed ona single system.

The code was in the original message

<%
set conn=3DServer.CreateObject("ADODB.Connection")
conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3D=
test;User Id=3Droot;Password=3Dyouwish"
conn.open
Response.write("Connected")
conn.close
%>



So line 4 is: conn.open


Thanks,
Adam

-----Original Message-----
From: Barry Stear [mailto:bstear@gmail.com]=20
Sent: Wednesday, December 23, 2009 11:28 AM
To: PHP DB Posts
Subject: Re: [PHP-DB] RE: Help for a beginner

Adam,

What is at Line 4 in your test.asp? The error you provided said that there
was a problem where it could not find the default driver to use.

Also when you get the connection failed you were trying to connect to MYSQL
from the system running MYSQL correct?

On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni wrot=
e:

> Giff,
>
> Not sure what you mean, and I suspect this is because of my confusion
> around PMA (as mentioned originally) SO let me elaborate...
>
>
>
> In my config.inc.php I changed pma to root and the pma password to the ro=
ot
> password for mysql
> When I browse to the phpmyadmin page I neter root and the root password f=
or
> mysql
>
> Thanks,
> Adam
>
> -----Original Message-----
> From: Giff Hammar [mailto:ghammar@sv-phoenix.com]
> Sent: Wednesday, December 23, 2009 10:41 AM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> It looks like you are not connecting because of a user name/password
> combination. Typically, Windows does not use root as a valid login as do
> most other operating systems. Try using your login information to see if
> you can connect to mySQL using the GUI. I suspect you'll succeed. The
> other option would be to use the mySQL admin user name and password. One
> of those should work.
>
> Once you can connect to your database with the GUI, you can then use PHP
> to call the mySQL database connect strings and manipulate your data as
> necessary. The DBD/DBI is a more generic solution that allows you to use
> a standard coding structure in PHP (or perl) and easily change databases
> underneath. For a small implementation, this isn't necessary. There are
> other database abstraction layers that perform the same function.
>
> Giff
>
> On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > why dont u install the xampp....
> >
> > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni > >wrote:
> >
> > > Mr. Brookhouse,
> > >
> > > Thanks for the quick reply. I am guessing it is not relevant to my ca=
se
> > > because I am not using PERL. I cannot find anything that says PHP
> requires
> > > PERL so I suspect Iam ok in this regard.
> > >
> > > Thank You,
> > > Adam
> > >
> > >
> > > -----Original Message-----
> > > From: Edward Brookhouse [mailto:ebroo@healthydirections.com]
> > > Sent: Wednesday, December 23, 2009 9:59 AM
> > > To: Adam Sonzogni; php-db@lists.php.net
> > > Subject: RE: Help for a beginner
> > >
> > > Just a guess, as I have not tried a full stack in windows, but in any
> unix
> > > if you are connecting php and mysql, you need something in the middle
> like
> > > DBD::mysql
> > >
> > > See if this helps: http://forums.mysql.com/read.php?51,189692,189856
> > >
> > >
> > > -----Original Message-----
> > > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]
> > > Sent: Wednesday, December 23, 2009 9:52 AM
> > > To: php-db@lists.php.net
> > > Subject: [PHP-DB] Help for a beginner
> > >
> > > Hi everyone, first thank you for ALL help and the understanding that =
I
> am
> > > new to PHP and MySQL. This is a long email and for that I apologize b=
ut
> I am
> > > trying to provide as much detail as possible. If this is the wrong li=
st
> to
> > > ask for help, kindly direct me to the proper authority.
> > >
> > > I am trying to learn and I have built the following environment.
> > >
> > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > > mysql-essential-5.1.41-win32
> > > php-5.3.1-nts-Win32-VC9-x86.msi
> > > phpMyAdmin-3.2.4-english.zip
> > >
> > >
> > > I followed the steps as detailed below (I already had IIS7 and CGI
> > > installed)
> > >
> > >
> > > 1. Install CGI & PHP
> > >
> http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
> > >
> > > 2. Install MySQL
> > > http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10=
/
> > >
> > > 3. Install PHPMyAdmin
> > >
> > >
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-=
2008/2008-09-16/
> > >
> > >
> > > After I completed the installations
> > > 1. If I navigate to the PHP directory and type php -info it spews a t=
on
> of
> > > data at me
> > > AND
> > > I created info.php which contains:
> > > When I browse this, it correctly produces a page with all the info
> about
> > > my PHP server. Although I do not understand much of it I believe this
> > > confirms PHP is working correctly with IIS
> > >
> > > 2. I open the MySQL CLI and perform the commands outlined in Step 23 =
at
> > > this page
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This returns the expected results, confirming MySQL is working
> > >
> > > 3. PHP is configured to work with php_mysql.dll as per the steps in t=
he
> > > trainsignal links above so I begin!
> > > I go to the phpmyadmin page, enter root and my password and after a
> long
> > > time I get a FastCGI error. I am not ready to believe it because, in
> classic
> > > MS form, it has several VERY different potential causes, and I have
> covered
> > > all of those. Plus the error code is 0x00000000 which is like saying
> > > nothing... I start thinking maybe it is not connecting to the mYSQL
> server
> > > right, the instructions re: pma and the password made no sense to me =
so
> I
> > > fiddle with that with no change.
> > >
> > >
> > > I write the mysql_test.php page in step 5 of
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This fails with: A connection attempt failed because the connected
> party
> > > did not properly respond after a period of time, or established
> connection
> > > failed because connected host has failed to respond.
> > >
> > > Because the PHP failed I try with ASP...
> > > <%
> > > set conn=3DServer.CreateObject("ADODB.Connection")
> > >
> conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3Dt=
est;User
> > > Id=3Droot;Password=3Dyouwish"
> > > conn.open
> > > Response.write("Connected")
> > > conn.close
> > > %>
> > >
> > > This returns:
> > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > [Microsoft][ODBC Driver Manager] Data source name not found and
> no
> > > default driver specified
> > > /test.asp, line 4
> > >
> > > I believe I have established MySQL is working, but for some reason it
> > > appears that it cannot be "reached" This IS on the same server so
> firewall
> > > should not be an issue, PLUS I confirmed the installer did create a
> hole. I
> > > turn off the MS firewall to be safe, no change.... I try a "repair" o=
f
> > > MySQL, I uninstall, reboot and reinstall with no change.
> > >
> > > NOTE: at several points I have tried iisreset and/or rebooting the
> system
> > > with no change.
> > >
> > > I start to research the matter and my mind is now unglued. I found
> > > something referencing using mcrypt with PHPMyAdmin to speed it up and
> > > wondered if maybe the long delay before the FastCGI error could be
> resolved
> > > so I tracked down the dll, put it in my ext directory and changed my
> php.ini
> > > to reflect this -- file found at
> http://files.edin.dk/php/win32/mcrypt/
> > >
> > > I found quite a bit about using libmysql.dll but there was no such fi=
le
> in
> > > my install, I pulled down the .zip package and that also did not
> contain it,
> > > I eventually found it in a 5.2.x archive but that does not seem to ha=
ve
> > > helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> > > mysqli. None of this seems to have done anything to change my
> situation.
> > >
> > > Again, I apologize for the lengthy message, I hope I have accurately
> > > described my issue in the right amount of detail.
> > >
> > > Thank You!
> > > Adam Sonzogni
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--=20

=3D"88"
height=3D"31">

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: RE: Help for a beginner

--000e0cd3f2f6841dd9047b684e40
Content-Type: text/plain; charset=ISO-8859-1

Well I am not familiar with ASP. You might want to check to make sure that
you didn't make any typos in your mysql_test.php page. I would suggest
seeing if you can connect through phpMyAdmin. That might give you a better
idea of where the problem lies.


On Wed, Dec 23, 2009 at 8:31 AM, Adam Sonzogni wrote:

> Barry,
>
> Yes this is all installed ona single system.
>
> The code was in the original message
>
> <%
> set conn=Server.CreateObject("ADODB.Connection")
> conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User
> Id=root;Password=youwish"
> conn.open
> Response.write("Connected")
> conn.close
> %>
>
>
>
> So line 4 is: conn.open
>
>
> Thanks,
> Adam
>
> -----Original Message-----
> From: Barry Stear [mailto:bstear@gmail.com]
> Sent: Wednesday, December 23, 2009 11:28 AM
> To: PHP DB Posts
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> Adam,
>
> What is at Line 4 in your test.asp? The error you provided said that there
> was a problem where it could not find the default driver to use.
>
> Also when you get the connection failed you were trying to connect to MYSQL
> from the system running MYSQL correct?
>
> On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni > >wrote:
>
> > Giff,
> >
> > Not sure what you mean, and I suspect this is because of my confusion
> > around PMA (as mentioned originally) SO let me elaborate...
> >
> >
> >
> > In my config.inc.php I changed pma to root and the pma password to the
> root
> > password for mysql
> > When I browse to the phpmyadmin page I neter root and the root password
> for
> > mysql
> >
> > Thanks,
> > Adam
> >
> > -----Original Message-----
> > From: Giff Hammar [mailto:ghammar@sv-phoenix.com]
> > Sent: Wednesday, December 23, 2009 10:41 AM
> > To: php-db@lists.php.net
> > Subject: Re: [PHP-DB] RE: Help for a beginner
> >
> > It looks like you are not connecting because of a user name/password
> > combination. Typically, Windows does not use root as a valid login as do
> > most other operating systems. Try using your login information to see if
> > you can connect to mySQL using the GUI. I suspect you'll succeed. The
> > other option would be to use the mySQL admin user name and password. One
> > of those should work.
> >
> > Once you can connect to your database with the GUI, you can then use PHP
> > to call the mySQL database connect strings and manipulate your data as
> > necessary. The DBD/DBI is a more generic solution that allows you to use
> > a standard coding structure in PHP (or perl) and easily change databases
> > underneath. For a small implementation, this isn't necessary. There are
> > other database abstraction layers that perform the same function.
> >
> > Giff
> >
> > On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > > why dont u install the xampp....
> > >
> > > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni > > >wrote:
> > >
> > > > Mr. Brookhouse,
> > > >
> > > > Thanks for the quick reply. I am guessing it is not relevant to my
> case
> > > > because I am not using PERL. I cannot find anything that says PHP
> > requires
> > > > PERL so I suspect Iam ok in this regard.
> > > >
> > > > Thank You,
> > > > Adam
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Edward Brookhouse [mailto:ebroo@healthydirections.com]
> > > > Sent: Wednesday, December 23, 2009 9:59 AM
> > > > To: Adam Sonzogni; php-db@lists.php.net
> > > > Subject: RE: Help for a beginner
> > > >
> > > > Just a guess, as I have not tried a full stack in windows, but in any
> > unix
> > > > if you are connecting php and mysql, you need something in the middle
> > like
> > > > DBD::mysql
> > > >
> > > > See if this helps: http://forums.mysql.com/read.php?51,189692,189856
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]
> > > > Sent: Wednesday, December 23, 2009 9:52 AM
> > > > To: php-db@lists.php.net
> > > > Subject: [PHP-DB] Help for a beginner
> > > >
> > > > Hi everyone, first thank you for ALL help and the understanding that
> I
> > am
> > > > new to PHP and MySQL. This is a long email and for that I apologize
> but
> > I am
> > > > trying to provide as much detail as possible. If this is the wrong
> list
> > to
> > > > ask for help, kindly direct me to the proper authority.
> > > >
> > > > I am trying to learn and I have built the following environment.
> > > >
> > > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > > > mysql-essential-5.1.41-win32
> > > > php-5.3.1-nts-Win32-VC9-x86.msi
> > > > phpMyAdmin-3.2.4-english.zip
> > > >
> > > >
> > > > I followed the steps as detailed below (I already had IIS7 and CGI
> > > > installed)
> > > >
> > > >
> > > > 1. Install CGI & PHP
> > > >
> > http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
> > > >
> > > > 2. Install MySQL
> > > >
> http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
> > > >
> > > > 3. Install PHPMyAdmin
> > > >
> > > >
> >
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-2008/2008-09-16/
> > > >
> > > >
> > > > After I completed the installations
> > > > 1. If I navigate to the PHP directory and type php -info it spews a
> ton
> > of
> > > > data at me
> > > > AND
> > > > I created info.php which contains:
> > > > When I browse this, it correctly produces a page with all the info
> > about
> > > > my PHP server. Although I do not understand much of it I believe this
> > > > confirms PHP is working correctly with IIS
> > > >
> > > > 2. I open the MySQL CLI and perform the commands outlined in Step 23
> at
> > > > this page
> > > > http://www.bicubica.com/apache-php-mysql/index.php
> > > > This returns the expected results, confirming MySQL is working
> > > >
> > > > 3. PHP is configured to work with php_mysql.dll as per the steps in
> the
> > > > trainsignal links above so I begin!
> > > > I go to the phpmyadmin page, enter root and my password and after a
> > long
> > > > time I get a FastCGI error. I am not ready to believe it because, in
> > classic
> > > > MS form, it has several VERY different potential causes, and I have
> > covered
> > > > all of those. Plus the error code is 0x00000000 which is like saying
> > > > nothing... I start thinking maybe it is not connecting to the mYSQL
> > server
> > > > right, the instructions re: pma and the password made no sense to me
> so
> > I
> > > > fiddle with that with no change.
> > > >
> > > >
> > > > I write the mysql_test.php page in step 5 of
> > > > http://www.bicubica.com/apache-php-mysql/index.php
> > > > This fails with: A connection attempt failed because the connected
> > party
> > > > did not properly respond after a period of time, or established
> > connection
> > > > failed because connected host has failed to respond.
> > > >
> > > > Because the PHP failed I try with ASP...
> > > > <%
> > > > set conn=Server.CreateObject("ADODB.Connection")
> > > >
> > conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User
> > > > Id=root;Password=youwish"
> > > > conn.open
> > > > Response.write("Connected")
> > > > conn.close
> > > > %>
> > > >
> > > > This returns:
> > > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > > [Microsoft][ODBC Driver Manager] Data source name not found and
> > no
> > > > default driver specified
> > > > /test.asp, line 4
> > > >
> > > > I believe I have established MySQL is working, but for some reason it
> > > > appears that it cannot be "reached" This IS on the same server so
> > firewall
> > > > should not be an issue, PLUS I confirmed the installer did create a
> > hole. I
> > > > turn off the MS firewall to be safe, no change.... I try a "repair"
> of
> > > > MySQL, I uninstall, reboot and reinstall with no change.
> > > >
> > > > NOTE: at several points I have tried iisreset and/or rebooting the
> > system
> > > > with no change.
> > > >
> > > > I start to research the matter and my mind is now unglued. I found
> > > > something referencing using mcrypt with PHPMyAdmin to speed it up and
> > > > wondered if maybe the long delay before the FastCGI error could be
> > resolved
> > > > so I tracked down the dll, put it in my ext directory and changed my
> > php.ini
> > > > to reflect this -- file found at
> > http://files.edin.dk/php/win32/mcrypt/
> > > >
> > > > I found quite a bit about using libmysql.dll but there was no such
> file
> > in
> > > > my install, I pulled down the .zip package and that also did not
> > contain it,
> > > > I eventually found it in a 5.2.x archive but that does not seem to
> have
> > > > helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> > > > mysqli. None of this seems to have done anything to change my
> > situation.
> > > >
> > > > Again, I apologize for the lengthy message, I hope I have accurately
> > > > described my issue in the right amount of detail.
> > > >
> > > > Thank You!
> > > > Adam Sonzogni
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > >
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
>
> > width="88"
> height="31">
>



--

height="31">

--000e0cd3f2f6841dd9047b684e40--

RE: RE: Help for a beginner

--_000_B1444D4F8602BF469416C025FC361DB501BA703046BFsfexchang es_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

If you read the thread I useda php page totest mysql connectivity after php=
myadmin did not work...

At this point I am willing to pay someone to troubleshoot this as I am baff=
led there is no definitive troubleshooting documentation for Windows instal=
ls.


From: Barry Stear [mailto:bstear@gmail.com]
Sent: Wednesday, December 23, 2009 12:04 PM
To: Adam Sonzogni
Cc: PHP DB Posts
Subject: Re: [PHP-DB] RE: Help for a beginner

Well I am not familiar with ASP. You might want to check to make sure that=
you didn't make any typos in your mysql_test.php page. I would suggest see=
ing if you can connect through phpMyAdmin. That might give you a better ide=
a of where the problem lies.

On Wed, Dec 23, 2009 at 8:31 AM, Adam Sonzogni to:asonzogni@setfocus.com>> wrote:
Barry,

Yes this is all installed ona single system.

The code was in the original message

<%
set conn=3DServer.CreateObject("ADODB.Connection")
conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3Dt=
est;User Id=3Droot;Password=3Dyouwish"
conn.open
Response.write("Connected")
conn.close
%>


So line 4 is: conn.open


Thanks,
Adam

-----Original Message-----
From: Barry Stear [mailto:bstear@gmail.com]
Sent: Wednesday, December 23, 2009 11:28 AM
To: PHP DB Posts
Subject: Re: [PHP-DB] RE: Help for a beginner

Adam,

What is at Line 4 in your test.asp? The error you provided said that there
was a problem where it could not find the default driver to use.

Also when you get the connection failed you were trying to connect to MYSQL
from the system running MYSQL correct?

On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni to:asonzogni@setfocus.com>>wrote:

> Giff,
>
> Not sure what you mean, and I suspect this is because of my confusion
> around PMA (as mentioned originally) SO let me elaborate...
>
>
>
> In my config.inc.php I changed pma to root and the pma password to the ro=
ot
> password for mysql
> When I browse to the phpmyadmin page I neter root and the root password f=
or
> mysql
>
> Thanks,
> Adam
>
> -----Original Message-----
> From: Giff Hammar [mailto:ghammar@sv-phoenix.com x.com>]
> Sent: Wednesday, December 23, 2009 10:41 AM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> It looks like you are not connecting because of a user name/password
> combination. Typically, Windows does not use root as a valid login as do
> most other operating systems. Try using your login information to see if
> you can connect to mySQL using the GUI. I suspect you'll succeed. The
> other option would be to use the mySQL admin user name and password. One
> of those should work.
>
> Once you can connect to your database with the GUI, you can then use PHP
> to call the mySQL database connect strings and manipulate your data as
> necessary. The DBD/DBI is a more generic solution that allows you to use
> a standard coding structure in PHP (or perl) and easily change databases
> underneath. For a small implementation, this isn't necessary. There are
> other database abstraction layers that perform the same function.
>
> Giff
>
> On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > why dont u install the xampp....
> >
> > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni mailto:asonzogni@setfocus.com>
> >wrote:
> >
> > > Mr. Brookhouse,
> > >
> > > Thanks for the quick reply. I am guessing it is not relevant to my ca=
se
> > > because I am not using PERL. I cannot find anything that says PHP
> requires
> > > PERL so I suspect Iam ok in this regard.
> > >
> > > Thank You,
> > > Adam
> > >
> > >
> > > -----Original Message-----
> > > From: Edward Brookhouse [mailto:ebroo@healthydirections.com roo@healthydirections.com>]
> > > Sent: Wednesday, December 23, 2009 9:59 AM
> > > To: Adam Sonzogni; php-db@lists.php.net
> > > Subject: RE: Help for a beginner
> > >
> > > Just a guess, as I have not tried a full stack in windows, but in any
> unix
> > > if you are connecting php and mysql, you need something in the middle
> like
> > > DBD::mysql
> > >
> > > See if this helps: http://forums.mysql.com/read.php?51,189692,189856
> > >
> > >
> > > -----Original Message-----
> > > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com etFocus.com>]
> > > Sent: Wednesday, December 23, 2009 9:52 AM
> > > To: php-db@lists.php.net
> > > Subject: [PHP-DB] Help for a beginner
> > >
> > > Hi everyone, first thank you for ALL help and the understanding that =
I
> am
> > > new to PHP and MySQL. This is a long email and for that I apologize b=
ut
> I am
> > > trying to provide as much detail as possible. If this is the wrong li=
st
> to
> > > ask for help, kindly direct me to the proper authority.
> > >
> > > I am trying to learn and I have built the following environment.
> > >
> > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > > mysql-essential-5.1.41-win32
> > > php-5.3.1-nts-Win32-VC9-x86.msi
> > > phpMyAdmin-3.2.4-english.zip
> > >
> > >
> > > I followed the steps as detailed below (I already had IIS7 and CGI
> > > installed)
> > >
> > >
> > > 1. Install CGI & PHP
> > >
> http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
> > >
> > > 2. Install MySQL
> > > http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10=
/
> > >
> > > 3. Install PHPMyAdmin
> > >
> > >
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-=
2008/2008-09-16/
> > >
> > >
> > > After I completed the installations
> > > 1. If I navigate to the PHP directory and type php -info it spews a t=
on
> of
> > > data at me
> > > AND
> > > I created info.php which contains:
> > > When I browse this, it correctly produces a page with all the info
> about
> > > my PHP server. Although I do not understand much of it I believe this
> > > confirms PHP is working correctly with IIS
> > >
> > > 2. I open the MySQL CLI and perform the commands outlined in Step 23 =
at
> > > this page
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This returns the expected results, confirming MySQL is working
> > >
> > > 3. PHP is configured to work with php_mysql.dll as per the steps in t=
he
> > > trainsignal links above so I begin!
> > > I go to the phpmyadmin page, enter root and my password and after a
> long
> > > time I get a FastCGI error. I am not ready to believe it because, in
> classic
> > > MS form, it has several VERY different potential causes, and I have
> covered
> > > all of those. Plus the error code is 0x00000000 which is like saying
> > > nothing... I start thinking maybe it is not connecting to the mYSQL
> server
> > > right, the instructions re: pma and the password made no sense to me =
so
> I
> > > fiddle with that with no change.
> > >
> > >
> > > I write the mysql_test.php page in step 5 of
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This fails with: A connection attempt failed because the connected
> party
> > > did not properly respond after a period of time, or established
> connection
> > > failed because connected host has failed to respond.
> > >
> > > Because the PHP failed I try with ASP...
> > > <%
> > > set conn=3DServer.CreateObject("ADODB.Connection")
> > >
> conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3Dt=
est;User
> > > Id=3Droot;Password=3Dyouwish"
> > > conn.open
> > > Response.write("Connected")
> > > conn.close
> > > %>
> > >
> > > This returns:
> > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > [Microsoft][ODBC Driver Manager] Data source name not found and
> no
> > > default driver specified
> > > /test.asp, line 4
> > >
> > > I believe I have established MySQL is working, but for some reason it
> > > appears that it cannot be "reached" This IS on the same server so
> firewall
> > > should not be an issue, PLUS I confirmed the installer did create a
> hole. I
> > > turn off the MS firewall to be safe, no change.... I try a "repair" o=
f
> > > MySQL, I uninstall, reboot and reinstall with no change.
> > >
> > > NOTE: at several points I have tried iisreset and/or rebooting the
> system
> > > with no change.
> > >
> > > I start to research the matter and my mind is now unglued. I found
> > > something referencing using mcrypt with PHPMyAdmin to speed it up and
> > > wondered if maybe the long delay before the FastCGI error could be
> resolved
> > > so I tracked down the dll, put it in my ext directory and changed my
> php.ini
> > > to reflect this -- file found at
> http://files.edin.dk/php/win32/mcrypt/
> > >
> > > I found quite a bit about using libmysql.dll but there was no such fi=
le
> in
> > > my install, I pulled down the .zip package and that also did not
> contain it,
> > > I eventually found it in a 5.2.x archive but that does not seem to ha=
ve
> > > helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> > > mysqli. None of this seems to have done anything to change my
> situation.
> > >
> > > Again, I apologize for the lengthy message, I hope I have accurately
> > > described my issue in the right amount of detail.
> > >
> > > Thank You!
> > > Adam Sonzogni
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--

=3D"88"
height=3D"31">



--

=3D"88" height=3D"31">

--_000_B1444D4F8602BF469416C025FC361DB501BA703046BFsfexchang es_--

Re: Displaying Password - orale...

Hi Karl,


>=20
> I did some search and found Zend Studio for MAC 5.5.
> it's $299, but thats a goal at least.

Just so you know I fully empathise with both yours and Daevid's =
situation - you'll probably find a lot of people on this list are in the =
same boat, as am I.

Anyway just a hint - I bought my first Mac in September and I'm never =
turning back but that's a conversation for another day. The one thing I =
thought was missing that I couldn't match on Windows was a decent IDE - =
for both PHP and C++ (my two main freelancer languages.)

However someone on this list pointed me in the direction of what I =
thought was a Java IDE - NetBeans. It turns out it's a damned-fine C++ =
and PHP editor. It handles code completion of LARGE projects (4,000+ =
files) ten times faster than others - Zend Studio and Eclipse, and =
Komodo for instance.

Plus it's free :)

http://netbeans.org/features/php/index.html

I used Zend Studio when it was a stand-alone Java application then =
switched to PhpEd but unfortunately that's Windows only. I've also =
tried Eclipse but couldn't get to grips with it. However I feel =
NetBeans is such a stronger contender than any of these - straight from =
the word go I just got on with it.

Re: the certification - I'm looking at doing a Zend course next year for =
nothing more than to try and get PHP recognised as a professional skill =
- I've been programming in it since 2002. I don't know of any other =
companies that do PHP qualifications, but as Zend is "the PHP company" =
anyway they probably mean more :P

Hope this helps you anyway.

Regards,
Andy=

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: RE: Help for a beginner

--000e0cd2de5ab47f5a047b69d854
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

I apologize I do see that you tried using phpmyadmin and received the
FastCGI error.

This might help you : http://www.php.net/manual/en/install.windows.iis7.php
.. Let me know what happens after you try those steps.. I am hoping for the
best..


On Wed, Dec 23, 2009 at 9:21 AM, Adam Sonzogni wrot=
e:

> If you read the thread I useda php page totest mysql connectivity after
> phpmyadmin did not work=85
>
>
>
> At this point I am willing to pay someone to troubleshoot this as I am
> baffled there is no definitive troubleshooting documentation for Windows
> installs.
>
>
>
>
>
> *From:* Barry Stear [mailto:bstear@gmail.com]
> *Sent:* Wednesday, December 23, 2009 12:04 PM
> *To:* Adam Sonzogni
> *Cc:* PHP DB Posts
>
> *Subject:* Re: [PHP-DB] RE: Help for a beginner
>
>
>
> Well I am not familiar with ASP. You might want to check to make sure th=
at
> you didn't make any typos in your mysql_test.php page. I would suggest
> seeing if you can connect through phpMyAdmin. That might give you a bette=
r
> idea of where the problem lies.
>
> On Wed, Dec 23, 2009 at 8:31 AM, Adam Sonzogni
> wrote:
>
> Barry,
>
> Yes this is all installed ona single system.
>
> The code was in the original message
>
>
> <%
> set conn=3DServer.CreateObject("ADODB.Connection")
> conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=
=3Dtest;User
> Id=3Droot;Password=3Dyouwish"
> conn.open
> Response.write("Connected")
> conn.close
> %>
>
>
> So line 4 is: conn.open
>
>
> Thanks,
> Adam
>
>
> -----Original Message-----
> From: Barry Stear [mailto:bstear@gmail.com]
> Sent: Wednesday, December 23, 2009 11:28 AM
> To: PHP DB Posts
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> Adam,
>
> What is at Line 4 in your test.asp? The error you provided said that ther=
e
> was a problem where it could not find the default driver to use.
>
> Also when you get the connection failed you were trying to connect to MYS=
QL
> from the system running MYSQL correct?
>
> On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni > >wrote:
>
> > Giff,
> >
> > Not sure what you mean, and I suspect this is because of my confusion
> > around PMA (as mentioned originally) SO let me elaborate...
> >
> >
> >
> > In my config.inc.php I changed pma to root and the pma password to the
> root
> > password for mysql
> > When I browse to the phpmyadmin page I neter root and the root password
> for
> > mysql
> >
> > Thanks,
> > Adam
> >
> > -----Original Message-----
> > From: Giff Hammar [mailto:ghammar@sv-phoenix.com]
> > Sent: Wednesday, December 23, 2009 10:41 AM
> > To: php-db@lists.php.net
> > Subject: Re: [PHP-DB] RE: Help for a beginner
> >
> > It looks like you are not connecting because of a user name/password
> > combination. Typically, Windows does not use root as a valid login as d=
o
> > most other operating systems. Try using your login information to see i=
f
> > you can connect to mySQL using the GUI. I suspect you'll succeed. The
> > other option would be to use the mySQL admin user name and password. On=
e
> > of those should work.
> >
> > Once you can connect to your database with the GUI, you can then use PH=
P
> > to call the mySQL database connect strings and manipulate your data as
> > necessary. The DBD/DBI is a more generic solution that allows you to us=
e
> > a standard coding structure in PHP (or perl) and easily change database=
s
> > underneath. For a small implementation, this isn't necessary. There are
> > other database abstraction layers that perform the same function.
> >
> > Giff
> >
> > On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > > why dont u install the xampp....
> > >
> > > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni m
> > >wrote:
> > >
> > > > Mr. Brookhouse,
> > > >
> > > > Thanks for the quick reply. I am guessing it is not relevant to my
> case
> > > > because I am not using PERL. I cannot find anything that says PHP
> > requires
> > > > PERL so I suspect Iam ok in this regard.
> > > >
> > > > Thank You,
> > > > Adam
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Edward Brookhouse [mailto:ebroo@healthydirections.com]
> > > > Sent: Wednesday, December 23, 2009 9:59 AM
> > > > To: Adam Sonzogni; php-db@lists.php.net
> > > > Subject: RE: Help for a beginner
> > > >
> > > > Just a guess, as I have not tried a full stack in windows, but in a=
ny
> > unix
> > > > if you are connecting php and mysql, you need something in the midd=
le
> > like
> > > > DBD::mysql
> > > >
> > > > See if this helps: http://forums.mysql.com/read.php?51,189692,18985=
6
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com]
> > > > Sent: Wednesday, December 23, 2009 9:52 AM
> > > > To: php-db@lists.php.net
> > > > Subject: [PHP-DB] Help for a beginner
> > > >
> > > > Hi everyone, first thank you for ALL help and the understanding tha=
t
> I
> > am
> > > > new to PHP and MySQL. This is a long email and for that I apologize
> but
> > I am
> > > > trying to provide as much detail as possible. If this is the wrong
> list
> > to
> > > > ask for help, kindly direct me to the proper authority.
> > > >
> > > > I am trying to learn and I have built the following environment.
> > > >
> > > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > > > mysql-essential-5.1.41-win32
> > > > php-5.3.1-nts-Win32-VC9-x86.msi
> > > > phpMyAdmin-3.2.4-english.zip
> > > >
> > > >
> > > > I followed the steps as detailed below (I already had IIS7 and CGI
> > > > installed)
> > > >
> > > >
> > > > 1. Install CGI & PHP
> > > >
> > http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04=
/
> > > >
> > > > 2. Install MySQL
> > > >
> http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
> > > >
> > > > 3. Install PHPMyAdmin
> > > >
> > > >
> >
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-=
2008/2008-09-16/
> > > >
> > > >
> > > > After I completed the installations
> > > > 1. If I navigate to the PHP directory and type php -info it spews a
> ton
> > of
> > > > data at me
> > > > AND
> > > > I created info.php which contains:
> > > > When I browse this, it correctly produces a page with all the inf=
o
> > about
> > > > my PHP server. Although I do not understand much of it I believe th=
is
> > > > confirms PHP is working correctly with IIS
> > > >
> > > > 2. I open the MySQL CLI and perform the commands outlined in Step 2=
3
> at
> > > > this page
> > > > http://www.bicubica.com/apache-php-mysql/index.php
> > > > This returns the expected results, confirming MySQL is working
> > > >
> > > > 3. PHP is configured to work with php_mysql.dll as per the steps in
> the
> > > > trainsignal links above so I begin!
> > > > I go to the phpmyadmin page, enter root and my password and after a
> > long
> > > > time I get a FastCGI error. I am not ready to believe it because, i=
n
> > classic
> > > > MS form, it has several VERY different potential causes, and I have
> > covered
> > > > all of those. Plus the error code is 0x00000000 which is like sayin=
g
> > > > nothing... I start thinking maybe it is not connecting to the mYSQL
> > server
> > > > right, the instructions re: pma and the password made no sense to m=
e
> so
> > I
> > > > fiddle with that with no change.
> > > >
> > > >
> > > > I write the mysql_test.php page in step 5 of
> > > > http://www.bicubica.com/apache-php-mysql/index.php
> > > > This fails with: A connection attempt failed because the connecte=
d
> > party
> > > > did not properly respond after a period of time, or established
> > connection
> > > > failed because connected host has failed to respond.
> > > >
> > > > Because the PHP failed I try with ASP...
> > > > <%
> > > > set conn=3DServer.CreateObject("ADODB.Connection")
> > > >
> > conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=
=3Dtest;User
> > > > Id=3Droot;Password=3Dyouwish"
> > > > conn.open
> > > > Response.write("Connected")
> > > > conn.close
> > > > %>
> > > >
> > > > This returns:
> > > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > > [Microsoft][ODBC Driver Manager] Data source name not found a=
nd
> > no
> > > > default driver specified
> > > > /test.asp, line 4
> > > >
> > > > I believe I have established MySQL is working, but for some reason =
it
> > > > appears that it cannot be "reached" This IS on the same server so
> > firewall
> > > > should not be an issue, PLUS I confirmed the installer did create a
> > hole. I
> > > > turn off the MS firewall to be safe, no change.... I try a "repair"
> of
> > > > MySQL, I uninstall, reboot and reinstall with no change.
> > > >
> > > > NOTE: at several points I have tried iisreset and/or rebooting the
> > system
> > > > with no change.
> > > >
> > > > I start to research the matter and my mind is now unglued. I found
> > > > something referencing using mcrypt with PHPMyAdmin to speed it up a=
nd
> > > > wondered if maybe the long delay before the FastCGI error could be
> > resolved
> > > > so I tracked down the dll, put it in my ext directory and changed m=
y
> > php.ini
> > > > to reflect this -- file found at
> > http://files.edin.dk/php/win32/mcrypt/
> > > >
> > > > I found quite a bit about using libmysql.dll but there was no such
> file
> > in
> > > > my install, I pulled down the .zip package and that also did not
> > contain it,
> > > > I eventually found it in a 5.2.x archive but that does not seem to
> have
> > > > helped. I have tried enabling: only mysql, mysql AND mysqli, and on=
ly
> > > > mysqli. None of this seems to have done anything to change my
> > situation.
> > > >
> > > > Again, I apologize for the lengthy message, I hope I have accuratel=
y
> > > > described my issue in the right amount of detail.
> > > >
> > > > Thank You!
> > > > Adam Sonzogni
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > >
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
>
> > width=3D"88"
> height=3D"31">
>
>
>
>
> --
>
> > width=3D"88" height=3D"31">
>



--=20

=3D"88"
height=3D"31">

--000e0cd2de5ab47f5a047b69d854--

RE: RE: Help for a beginner

--_000_B1444D4F8602BF469416C025FC361DB501BA703046C0sfexchang es_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Barry,

You sir saved the day, the very last item on that page was the ticket, I di=
sabled IPV6 but never thought to removed the localhost entry for ipv6 in ho=
sts...

That said I google'd dozens of times with a variety of keyword combinations=
all including iis7 and PHP, and not once did that page pop up :(



The default installation of Windows Vista, Windows 7 and Windows Server 200=
8 adds a line to the Windows/System32/drivers/etc/hosts which causes networ=
k functions (database connect functions too, like mysql_connect) to timeout=
when connecting to "localhost". To resolve this problem, remove the entry=
from the hosts file:
::1 localhost

or connect using the IP address, 127.0.0.1 or another domain name.

This behavior change is due to IPv6 being enabled by default in Vista or ot=
her recent Windows version.




From: Barry Stear [mailto:bstear@gmail.com]
Sent: Wednesday, December 23, 2009 1:54 PM
To: Adam Sonzogni; PHP DB Posts
Subject: Re: [PHP-DB] RE: Help for a beginner

I apologize I do see that you tried using phpmyadmin and received the FastC=
GI error.

This might help you : http://www.php.net/manual/en/install.windows.iis7.php=
. Let me know what happens after you try those steps.. I am hoping for t=
he best..


On Wed, Dec 23, 2009 at 9:21 AM, Adam Sonzogni to:asonzogni@setfocus.com>> wrote:
If you read the thread I useda php page totest mysql connectivity after php=
myadmin did not work...

At this point I am willing to pay someone to troubleshoot this as I am baff=
led there is no definitive troubleshooting documentation for Windows instal=
ls.


From: Barry Stear [mailto:bstear@gmail.com]
Sent: Wednesday, December 23, 2009 12:04 PM
To: Adam Sonzogni
Cc: PHP DB Posts

Subject: Re: [PHP-DB] RE: Help for a beginner

Well I am not familiar with ASP. You might want to check to make sure that=
you didn't make any typos in your mysql_test.php page. I would suggest see=
ing if you can connect through phpMyAdmin. That might give you a better ide=
a of where the problem lies.
On Wed, Dec 23, 2009 at 8:31 AM, Adam Sonzogni to:asonzogni@setfocus.com>> wrote:
Barry,

Yes this is all installed ona single system.

The code was in the original message

<%
set conn=3DServer.CreateObject("ADODB.Connection")
conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3Dt=
est;User Id=3Droot;Password=3Dyouwish"
conn.open
Response.write("Connected")
conn.close
%>

So line 4 is: conn.open


Thanks,
Adam

-----Original Message-----
From: Barry Stear [mailto:bstear@gmail.com]
Sent: Wednesday, December 23, 2009 11:28 AM
To: PHP DB Posts
Subject: Re: [PHP-DB] RE: Help for a beginner

Adam,

What is at Line 4 in your test.asp? The error you provided said that there
was a problem where it could not find the default driver to use.

Also when you get the connection failed you were trying to connect to MYSQL
from the system running MYSQL correct?

On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni to:asonzogni@setfocus.com>>wrote:

> Giff,
>
> Not sure what you mean, and I suspect this is because of my confusion
> around PMA (as mentioned originally) SO let me elaborate...
>
>
>
> In my config.inc.php I changed pma to root and the pma password to the ro=
ot
> password for mysql
> When I browse to the phpmyadmin page I neter root and the root password f=
or
> mysql
>
> Thanks,
> Adam
>
> -----Original Message-----
> From: Giff Hammar [mailto:ghammar@sv-phoenix.com x.com>]
> Sent: Wednesday, December 23, 2009 10:41 AM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> It looks like you are not connecting because of a user name/password
> combination. Typically, Windows does not use root as a valid login as do
> most other operating systems. Try using your login information to see if
> you can connect to mySQL using the GUI. I suspect you'll succeed. The
> other option would be to use the mySQL admin user name and password. One
> of those should work.
>
> Once you can connect to your database with the GUI, you can then use PHP
> to call the mySQL database connect strings and manipulate your data as
> necessary. The DBD/DBI is a more generic solution that allows you to use
> a standard coding structure in PHP (or perl) and easily change databases
> underneath. For a small implementation, this isn't necessary. There are
> other database abstraction layers that perform the same function.
>
> Giff
>
> On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > why dont u install the xampp....
> >
> > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni mailto:asonzogni@setfocus.com>
> >wrote:
> >
> > > Mr. Brookhouse,
> > >
> > > Thanks for the quick reply. I am guessing it is not relevant to my ca=
se
> > > because I am not using PERL. I cannot find anything that says PHP
> requires
> > > PERL so I suspect Iam ok in this regard.
> > >
> > > Thank You,
> > > Adam
> > >
> > >
> > > -----Original Message-----
> > > From: Edward Brookhouse [mailto:ebroo@healthydirections.com roo@healthydirections.com>]
> > > Sent: Wednesday, December 23, 2009 9:59 AM
> > > To: Adam Sonzogni; php-db@lists.php.net
> > > Subject: RE: Help for a beginner
> > >
> > > Just a guess, as I have not tried a full stack in windows, but in any
> unix
> > > if you are connecting php and mysql, you need something in the middle
> like
> > > DBD::mysql
> > >
> > > See if this helps: http://forums.mysql.com/read.php?51,189692,189856
> > >
> > >
> > > -----Original Message-----
> > > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com etFocus.com>]
> > > Sent: Wednesday, December 23, 2009 9:52 AM
> > > To: php-db@lists.php.net
> > > Subject: [PHP-DB] Help for a beginner
> > >
> > > Hi everyone, first thank you for ALL help and the understanding that =
I
> am
> > > new to PHP and MySQL. This is a long email and for that I apologize b=
ut
> I am
> > > trying to provide as much detail as possible. If this is the wrong li=
st
> to
> > > ask for help, kindly direct me to the proper authority.
> > >
> > > I am trying to learn and I have built the following environment.
> > >
> > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > > mysql-essential-5.1.41-win32
> > > php-5.3.1-nts-Win32-VC9-x86.msi
> > > phpMyAdmin-3.2.4-english.zip
> > >
> > >
> > > I followed the steps as detailed below (I already had IIS7 and CGI
> > > installed)
> > >
> > >
> > > 1. Install CGI & PHP
> > >
> http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
> > >
> > > 2. Install MySQL
> > > http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10=
/
> > >
> > > 3. Install PHPMyAdmin
> > >
> > >
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-=
2008/2008-09-16/
> > >
> > >
> > > After I completed the installations
> > > 1. If I navigate to the PHP directory and type php -info it spews a t=
on
> of
> > > data at me
> > > AND
> > > I created info.php which contains:
> > > When I browse this, it correctly produces a page with all the info
> about
> > > my PHP server. Although I do not understand much of it I believe this
> > > confirms PHP is working correctly with IIS
> > >
> > > 2. I open the MySQL CLI and perform the commands outlined in Step 23 =
at
> > > this page
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This returns the expected results, confirming MySQL is working
> > >
> > > 3. PHP is configured to work with php_mysql.dll as per the steps in t=
he
> > > trainsignal links above so I begin!
> > > I go to the phpmyadmin page, enter root and my password and after a
> long
> > > time I get a FastCGI error. I am not ready to believe it because, in
> classic
> > > MS form, it has several VERY different potential causes, and I have
> covered
> > > all of those. Plus the error code is 0x00000000 which is like saying
> > > nothing... I start thinking maybe it is not connecting to the mYSQL
> server
> > > right, the instructions re: pma and the password made no sense to me =
so
> I
> > > fiddle with that with no change.
> > >
> > >
> > > I write the mysql_test.php page in step 5 of
> > > http://www.bicubica.com/apache-php-mysql/index.php
> > > This fails with: A connection attempt failed because the connected
> party
> > > did not properly respond after a period of time, or established
> connection
> > > failed because connected host has failed to respond.
> > >
> > > Because the PHP failed I try with ASP...
> > > <%
> > > set conn=3DServer.CreateObject("ADODB.Connection")
> > >
> conn.ConnectionString=3D"Driver=3D{mySQL};Server=3Dlocalhost ;Database=3Dt=
est;User
> > > Id=3Droot;Password=3Dyouwish"
> > > conn.open
> > > Response.write("Connected")
> > > conn.close
> > > %>
> > >
> > > This returns:
> > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > [Microsoft][ODBC Driver Manager] Data source name not found and
> no
> > > default driver specified
> > > /test.asp, line 4
> > >
> > > I believe I have established MySQL is working, but for some reason it
> > > appears that it cannot be "reached" This IS on the same server so
> firewall
> > > should not be an issue, PLUS I confirmed the installer did create a
> hole. I
> > > turn off the MS firewall to be safe, no change.... I try a "repair" o=
f
> > > MySQL, I uninstall, reboot and reinstall with no change.
> > >
> > > NOTE: at several points I have tried iisreset and/or rebooting the
> system
> > > with no change.
> > >
> > > I start to research the matter and my mind is now unglued. I found
> > > something referencing using mcrypt with PHPMyAdmin to speed it up and
> > > wondered if maybe the long delay before the FastCGI error could be
> resolved
> > > so I tracked down the dll, put it in my ext directory and changed my
> php.ini
> > > to reflect this -- file found at
> http://files.edin.dk/php/win32/mcrypt/
> > >
> > > I found quite a bit about using libmysql.dll but there was no such fi=
le
> in
> > > my install, I pulled down the .zip package and that also did not
> contain it,
> > > I eventually found it in a 5.2.x archive but that does not seem to ha=
ve
> > > helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> > > mysqli. None of this seems to have done anything to change my
> situation.
> > >
> > > Again, I apologize for the lengthy message, I hope I have accurately
> > > described my issue in the right amount of detail.
> > >
> > > Thank You!
> > > Adam Sonzogni
> > >
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> > >
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


--

=3D"88"
height=3D"31">



--

=3D"88" height=3D"31">



--

=3D"88" height=3D"31">

--_000_B1444D4F8602BF469416C025FC361DB501BA703046C0sfexchang es_--

Re: RE: Help for a beginner

--000e0cd2de5ae0f62d047b6afb63
Content-Type: text/plain; charset=ISO-8859-1

I am glad that it worked for you. I knew that there was information out
there for configuring PHP under IIS. I just wasn't sure if it was on MYSQL
or PHP's site. You can go ahead and make a check out to my name for the
amount you were willing to pay to get this resolved.. Just email me
privately for my address :-)..




On Wed, Dec 23, 2009 at 11:24 AM, Adam Sonzogni wrote:

> Barry,
>
> You sir saved the day, the very last item on that page was the ticket, I
> disabled IPV6 but never thought to removed the localhost entry for ipv6 in
> hosts...
>
> That said I google'd dozens of times with a variety of keyword combinations
> all including iis7 and PHP, and not once did that page pop up :(
>
>
>
> The default installation of Windows Vista, Windows 7 and Windows Server
> 2008 adds a line to the Windows/System32/drivers/etc/hosts which causes
> network functions (database connect functions too, like mysql_connect) to
> timeout when connecting to "localhost". To resolve this problem, remove the
> entry from the hosts file:
> ::1 localhost
>
> or connect using the IP address, 127.0.0.1 or another domain name.
>
> This behavior change is due to IPv6 being enabled by default in Vista or
> other recent Windows version.
>
>
>
>
> From: Barry Stear [mailto:bstear@gmail.com]
> Sent: Wednesday, December 23, 2009 1:54 PM
> To: Adam Sonzogni; PHP DB Posts
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> I apologize I do see that you tried using phpmyadmin and received the
> FastCGI error.
>
> This might help you :
> http://www.php.net/manual/en/install.windows.iis7.php . Let me know what
> happens after you try those steps.. I am hoping for the best..
>
>
> On Wed, Dec 23, 2009 at 9:21 AM, Adam Sonzogni > > wrote:
> If you read the thread I useda php page totest mysql connectivity after
> phpmyadmin did not work...
>
> At this point I am willing to pay someone to troubleshoot this as I am
> baffled there is no definitive troubleshooting documentation for Windows
> installs.
>
>
> From: Barry Stear [mailto:bstear@gmail.com]
> Sent: Wednesday, December 23, 2009 12:04 PM
> To: Adam Sonzogni
> Cc: PHP DB Posts
>
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> Well I am not familiar with ASP. You might want to check to make sure that
> you didn't make any typos in your mysql_test.php page. I would suggest
> seeing if you can connect through phpMyAdmin. That might give you a better
> idea of where the problem lies.
> On Wed, Dec 23, 2009 at 8:31 AM, Adam Sonzogni > > wrote:
> Barry,
>
> Yes this is all installed ona single system.
>
> The code was in the original message
>
> <%
> set conn=Server.CreateObject("ADODB.Connection")
> conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User
> Id=root;Password=youwish"
> conn.open
> Response.write("Connected")
> conn.close
> %>
>
> So line 4 is: conn.open
>
>
> Thanks,
> Adam
>
> -----Original Message-----
> From: Barry Stear [mailto:bstear@gmail.com]
> Sent: Wednesday, December 23, 2009 11:28 AM
> To: PHP DB Posts
> Subject: Re: [PHP-DB] RE: Help for a beginner
>
> Adam,
>
> What is at Line 4 in your test.asp? The error you provided said that there
> was a problem where it could not find the default driver to use.
>
> Also when you get the connection failed you were trying to connect to MYSQL
> from the system running MYSQL correct?
>
> On Wed, Dec 23, 2009 at 7:50 AM, Adam Sonzogni > >wrote:
>
> > Giff,
> >
> > Not sure what you mean, and I suspect this is because of my confusion
> > around PMA (as mentioned originally) SO let me elaborate...
> >
> >
> >
> > In my config.inc.php I changed pma to root and the pma password to the
> root
> > password for mysql
> > When I browse to the phpmyadmin page I neter root and the root password
> for
> > mysql
> >
> > Thanks,
> > Adam
> >
> > -----Original Message-----
> > From: Giff Hammar [mailto:ghammar@sv-phoenix.com > ghammar@sv-phoenix.com>]
> > Sent: Wednesday, December 23, 2009 10:41 AM
> > To: php-db@lists.php.net
> > Subject: Re: [PHP-DB] RE: Help for a beginner
> >
> > It looks like you are not connecting because of a user name/password
> > combination. Typically, Windows does not use root as a valid login as do
> > most other operating systems. Try using your login information to see if
> > you can connect to mySQL using the GUI. I suspect you'll succeed. The
> > other option would be to use the mySQL admin user name and password. One
> > of those should work.
> >
> > Once you can connect to your database with the GUI, you can then use PHP
> > to call the mySQL database connect strings and manipulate your data as
> > necessary. The DBD/DBI is a more generic solution that allows you to use
> > a standard coding structure in PHP (or perl) and easily change databases
> > underneath. For a small implementation, this isn't necessary. There are
> > other database abstraction layers that perform the same function.
> >
> > Giff
> >
> > On Wed, 2009-12-23 at 20:46 +0530, Chaitanya Yanamadala wrote:
> > > why dont u install the xampp....
> > >
> > > On Wed, Dec 23, 2009 at 8:38 PM, Adam Sonzogni >
> > >wrote:
> > >
> > > > Mr. Brookhouse,
> > > >
> > > > Thanks for the quick reply. I am guessing it is not relevant to my
> case
> > > > because I am not using PERL. I cannot find anything that says PHP
> > requires
> > > > PERL so I suspect Iam ok in this regard.
> > > >
> > > > Thank You,
> > > > Adam
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Edward Brookhouse [mailto:ebroo@healthydirections.com > ebroo@healthydirections.com>]
> > > > Sent: Wednesday, December 23, 2009 9:59 AM
> > > > To: Adam Sonzogni; php-db@lists.php.net
> > > > Subject: RE: Help for a beginner
> > > >
> > > > Just a guess, as I have not tried a full stack in windows, but in any
> > unix
> > > > if you are connecting php and mysql, you need something in the middle
> > like
> > > > DBD::mysql
> > > >
> > > > See if this helps: http://forums.mysql.com/read.php?51,189692,189856
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Adam Sonzogni [mailto:asonzogni@SetFocus.com > asonzogni@SetFocus.com>]
> > > > Sent: Wednesday, December 23, 2009 9:52 AM
> > > > To: php-db@lists.php.net
> > > > Subject: [PHP-DB] Help for a beginner
> > > >
> > > > Hi everyone, first thank you for ALL help and the understanding that
> I
> > am
> > > > new to PHP and MySQL. This is a long email and for that I apologize
> but
> > I am
> > > > trying to provide as much detail as possible. If this is the wrong
> list
> > to
> > > > ask for help, kindly direct me to the proper authority.
> > > >
> > > > I am trying to learn and I have built the following environment.
> > > >
> > > > Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> > > > mysql-essential-5.1.41-win32
> > > > php-5.3.1-nts-Win32-VC9-x86.msi
> > > > phpMyAdmin-3.2.4-english.zip
> > > >
> > > >
> > > > I followed the steps as detailed below (I already had IIS7 and CGI
> > > > installed)
> > > >
> > > >
> > > > 1. Install CGI & PHP
> > > >
> > http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
> > > >
> > > > 2. Install MySQL
> > > >
> http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
> > > >
> > > > 3. Install PHPMyAdmin
> > > >
> > > >
> >
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-2008/2008-09-16/
> > > >
> > > >
> > > > After I completed the installations
> > > > 1. If I navigate to the PHP directory and type php -info it spews a
> ton
> > of
> > > > data at me
> > > > AND
> > > > I created info.php which contains:
> > > > When I browse this, it correctly produces a page with all the info
> > about
> > > > my PHP server. Although I do not understand much of it I believe this
> > > > confirms PHP is working correctly with IIS
> > > >
> > > > 2. I open the MySQL CLI and perform the commands outlined in Step 23
> at
> > > > this page
> > > > http://www.bicubica.com/apache-php-mysql/index.php
> > > > This returns the expected results, confirming MySQL is working
> > > >
> > > > 3. PHP is configured to work with php_mysql.dll as per the steps in
> the
> > > > trainsignal links above so I begin!
> > > > I go to the phpmyadmin page, enter root and my password and after a
> > long
> > > > time I get a FastCGI error. I am not ready to believe it because, in
> > classic
> > > > MS form, it has several VERY different potential causes, and I have
> > covered
> > > > all of those. Plus the error code is 0x00000000 which is like saying
> > > > nothing... I start thinking maybe it is not connecting to the mYSQL
> > server
> > > > right, the instructions re: pma and the password made no sense to me
> so
> > I
> > > > fiddle with that with no change.
> > > >
> > > >
> > > > I write the mysql_test.php page in step 5 of
> > > > http://www.bicubica.com/apache-php-mysql/index.php
> > > > This fails with: A connection attempt failed because the connected
> > party
> > > > did not properly respond after a period of time, or established
> > connection
> > > > failed because connected host has failed to respond.
> > > >
> > > > Because the PHP failed I try with ASP...
> > > > <%
> > > > set conn=Server.CreateObject("ADODB.Connection")
> > > >
> > conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User
> > > > Id=root;Password=youwish"
> > > > conn.open
> > > > Response.write("Connected")
> > > > conn.close
> > > > %>
> > > >
> > > > This returns:
> > > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > > > [Microsoft][ODBC Driver Manager] Data source name not found and
> > no
> > > > default driver specified
> > > > /test.asp, line 4
> > > >
> > > > I believe I have established MySQL is working, but for some reason it
> > > > appears that it cannot be "reached" This IS on the same server so
> > firewall
> > > > should not be an issue, PLUS I confirmed the installer did create a
> > hole. I
> > > > turn off the MS firewall to be safe, no change.... I try a "repair"
> of
> > > > MySQL, I uninstall, reboot and reinstall with no change.
> > > >
> > > > NOTE: at several points I have tried iisreset and/or rebooting the
> > system
> > > > with no change.
> > > >
> > > > I start to research the matter and my mind is now unglued. I found
> > > > something referencing using mcrypt with PHPMyAdmin to speed it up and
> > > > wondered if maybe the long delay before the FastCGI error could be
> > resolved
> > > > so I tracked down the dll, put it in my ext directory and changed my
> > php.ini
> > > > to reflect this -- file found at
> > http://files.edin.dk/php/win32/mcrypt/
> > > >
> > > > I found quite a bit about using libmysql.dll but there was no such
> file
> > in
> > > > my install, I pulled down the .zip package and that also did not
> > contain it,
> > > > I eventually found it in a 5.2.x archive but that does not seem to
> have
> > > > helped. I have tried enabling: only mysql, mysql AND mysqli, and only
> > > > mysqli. None of this seems to have done anything to change my
> > situation.
> > > >
> > > > Again, I apologize for the lengthy message, I hope I have accurately
> > > > described my issue in the right amount of detail.
> > > >
> > > > Thank You!
> > > > Adam Sonzogni
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > --
> > > > PHP Database Mailing List (http://www.php.net/)
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > >
> > >
> > >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
>
> > width="88"
> height="31">
>
>
>
> --
>
> > width="88" height="31">
>
>
>
> --
>
> > width="88" height="31">
>



--

height="31">

--000e0cd2de5ae0f62d047b6afb63--

Re: RE: Help for a beginner

--Apple-Mail-2--172043584
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

>=20
> The default installation of Windows Vista, Windows 7 and Windows =
Server 2008 adds a line to the Windows/System32/drivers/etc/hosts which =
causes network functions (database connect functions too, like =
mysql_connect) to timeout when connecting to "localhost". To resolve =
this problem, remove the entry from the hosts file:
> ::1 localhost
>=20
> or connect using the IP address, 127.0.0.1 or another domain name.


Just FYI, this is also the default on newer Linux versions - Ubuntu 9.10 =
being a prime example. Connecting to "localhost" creates an IPv6 =
connection. Some utilities (e.g. telnet) fall back to trying IPv4 if =
the v6 connection fails.

Regards,
Andy=

--Apple-Mail-2--172043584--

Re: Help for a beginner

Hi

> Hi everyone, first thank you for ALL help and the understanding that I am new to PHP and MySQL. This is a long email and for that I apologize but I am trying to provide as much detail as possible. If this is the wrong list to ask for help, kindly direct me to the proper authority.
>
> I am trying to learn and I have built the following environment.
>
> Windows Server 2008 Standard 32bit service Pack 2 with IIS7
> mysql-essential-5.1.41-win32
> php-5.3.1-nts-Win32-VC9-x86.msi
> phpMyAdmin-3.2.4-english.zip
>
>
> I followed the steps as detailed below (I already had IIS7 and CGI installed)
>
>
> 1. Install CGI & PHP
> http://www.trainsignaltraining.com/iis-7-install-fastcgi-php /2008-09-04/
>
> 2. Install MySQL
> http://www.trainsignaltraining.com/install-mysql-on-iis7/200 8-09-10/
>
> 3. Install PHPMyAdmin
> http://www.trainsignaltraining.com/install-phpmyadmin-on-iis 7-and-server-2008/2008-09-16/

This is a bit vague on details. In particular, when installing PHP did
you add the required extensions for MySQL, etc at step 6?
Create a test page containing nothing but this:

phpinfo();
?>

Open the page in your browser and verify that mysql, gd, and mbstring
are included. This will verify that:
1) you added them to your php.ini
and
2) This is the INI file actually being used by the server and not some
random other.

> After I completed the installations
> 1. If I navigate to the PHP directory and type php -info it spews a ton of data at me
> AND
> I created info.php which contains:
> When I browse this, it correctly produces a page with all the info about my PHP server. Although I do not understand much of it I believe this confirms PHP is working correctly with IIS
>
> 2. I open the MySQL CLI and perform the commands outlined in Step 23 at this page
> http://www.bicubica.com/apache-php-mysql/index.php
> This returns the expected results, confirming MySQL is working
>
> 3. PHP is configured to work with php_mysql.dll as per the steps in the trainsignal links above so I begin!
> I go to the phpmyadmin page, enter root and my password and after a long time I get a FastCGI error. I am not ready to believe it because, in classic MS form, it has several VERY different potential causes, and I have covered all of those. Plus the error code is 0x00000000 which is like saying nothing... I start thinking maybe it is not connecting to the mYSQL server right, the instructions re: pma and the password made no sense to me so I fiddle with that with no change.
>
>
> I write the mysql_test.php page in step 5 of http://www.bicubica.com/apache-php-mysql/index.php
> This fails with: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
>
> Because the PHP failed I try with ASP...
> <%
> set conn=Server.CreateObject("ADODB.Connection")
> conn.ConnectionString="Driver={mySQL};Server=localhost;Datab ase=test;User Id=root;Password=youwish"
> conn.open
> Response.write("Connected")
> conn.close
> %>
>
> This returns:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
> /test.asp, line 4
>
> I believe I have established MySQL is working, but for some reason it appears that it cannot be "reached" This IS on the same server so firewall should not be an issue, PLUS I confirmed the installer did create a hole. I turn off the MS firewall to be safe, no change.... I try a "repair" of MySQL, I uninstall, reboot and reinstall with no change.
>
> NOTE: at several points I have tried iisreset and/or rebooting the system with no change.
>
> I start to research the matter and my mind is now unglued. I found something referencing using mcrypt with PHPMyAdmin to speed it up and wondered if maybe the long delay before the FastCGI error could be resolved so I tracked down the dll, put it in my ext directory and changed my php.ini to reflect this -- file found at http://files.edin.dk/php/win32/mcrypt/
>
> I found quite a bit about using libmysql.dll but there was no such file in my install, I pulled down the .zip package and that also did not contain it, I eventually found it in a 5.2.x archive but that does not seem to have helped. I have tried enabling: only mysql, mysql AND mysqli, and only mysqli. None of this seems to have done anything to change my situation.
>
> Again, I apologize for the lengthy message, I hope I have accurately described my issue in the right amount of detail.
>
> Thank You!
> Adam Sonzogni
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

--
Niel Archer
niel.archer (at) blueyonder.co.uk



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php